Change the date to current date in a column in excel

[Kunal_Jain]

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.
@shreyash_shirbhate

[Gokul001 (Gokul Balaji)]

Can you share the Output also @Kunal_Jain

[Kunal_Jain]

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

[postwick (Paul)]

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).

[Gokul001 (Gokul Balaji)]

Just use Write cell activity @Kunal_Jain

DateTime.Now.ToString("dd-MM-yyyy")

Check out the image for better understanding

Regards
Gokul