Change the date to current date in a column in excel

How to change the date present in column to current date and write it back into the same position
Here I have attached the sheet for the same
Wo.xlsx (9.8 KB)

We need to change the date at G1.

Can you share the Output also @Kunal_Jain

Wo.xlsx (9.8 KB)
Output has to be replaced with current date

Read Range into a datatable. Change the dates in the datatable. Write Range back to Excel to overwrite all the existing data, or to a new file (and delete the old file).

Just use Write cell activity @Kunal_Jain


Check out the image for better understanding



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.