How to constant =today() function

[deepak_message]

Hi,

I am looking to constant =today() function , if I open the file another day.

Actually, if I am using this function in excel and an open another day it shows the current day. but I am looking that date should be not change.

Please help.

 

[wigi]

This question is asked a lot of times, so please first use the search function.

See:

http://www.mcgimpsey.com/excel/timestamp.html

If you still have questions afterwards, please ask them.

 

[deepak_message]

Not able to get the answer in the above url. please help

 

[wigi]

It's under the header: "Using a worksheet event macro"

Obviously you will need to change certain things and also try it yourself.

 

[hasanlianar]

Hi,

You can enter date manually or you can use Ctrl; shortcut to enter current date.