Seeker1

[Seeker1]

Hi, I am an excel novice and I wish to add a "last Updated" date and time in cell A2 of sheet 1. How can I achieve this, can anyone assist?

 

[cyrilbrd]

Hi
do you mean the present date and time?
=today() would return the day, month and year
=now() would return in addition to first formula the time in hour and minutes.

 

[Seeker1]

Thanks for coming back to me. The exact issue I have is I need to be able to retain the date the sheet was changed. In other words if I opened and changed some data / detail today and saved it I need the sheet to retain the changes until the next time it is changed / saved. i need to be able to do this for auditing purposes.

 

[cyrilbrd]

have you read this?

link.

 

[Seeker1]

Hi, I am sorry I am a bit thick, I looked at the link but still none the wiser!!

 

[cyrilbrd]

ok no problem, what about this example here?
would that be useful?

link.