Enter date when cell is filled

[Bandito1]

Hi all,

I would like to record when data is added in my excel file.

Tricky thing is that it has to start from row 548 and onwards.

If data is in cell B548 i get the date of when the data is entered in cell A548.
How do i do this?

 

[sandy666]

maybe this:
https://www.mrexcel.com/forum/excel-questions/1095311-excel-static-date-post5265398.html#post5265398
adjust reference to your neeeds

 

[Bandito1]

Yes i think so

But this formule should be enough right?

=IF(B547="";"";NOW())

 

[MARK858]

Yes i think so

But this formule should be enough right?

=IF(B547="";"";NOW())

Depends if you want it to update each time the worksheet calculates (if you are only concerned with the date then the date will change at midnight) unless you are going to change the Iterative calculation as in the link which I don't like doing and use the syntax in the link.