Static =TODAY() Function

[dparteka]

Does anyone know if there is a way to use =TODAY() in a formula and once the date appears it never changes, I'm looking at something like this... thanks for looking.

=IF(A1="","",TODAY())

 

[Chihiro]

Why not use... shortcut key if you don't need date changed.
CTRL + ; (semi-colon).

EDIT:
Ah, guess I've misread the question. In that case, you will need circular reference to the cell containing formula. So if A1 is being edited by user and B1 contains formula...
=IF(A1<>"",IF(B1="",TODAY(),B1),"")

 

[Thangavel]

Hope this will help you!
=IF(A1 = 0,TODAY(),A1)

 

[dparteka]

Thanks guys, I appreciate the help

 

[Thangavel]

Much appreciate if you like our replies!!!