I want excel code

Help Forum
,
1

Hello team, I’m looking for a code. It will detect the date value used in the Excel row where the transaction was made and will create the “Status” column by going up to “MaxDataCount * 2 + 1” from this date. A value will be written as text in the relevant date cell of the column it creates.

12345
12345970×657 5.46 KB

2

Can you clarify the request?
Here I understand that we will find the date value that the status side has value
For example
image
regards,

3

Hi @7e0cf1013f6538ba590f9f391 ,

Your query is not clear could you elaborate on this part with an example:

will create the “Status” column by going up to “MaxDataCount * 2 + 1” from this date. A value will be written as text in the relevant date cell of the column it creates.

Regards,
Geetishree Rao

5

Hi @7e0cf1013f6538ba590f9f391 ,

It’s still not clear.Why have you set

What is this MaxDatacount? is it The last date entry?
Please explain with proper inputs and output and where you want to print the output.