excel time stamp

[surveyor kyle]

i have a code , =IF(G4="","",IF(H4="",NOW(),H4)), that returns my date
as january 00, 1900. Does anyone know what the problem is and how to
fix it? thanks for your help.

 

[Max]

" january 00, 1900" is simply a zero (you can format the cell as
general to see this)
which means H4 probably contains a zero (masked?)

Perhaps this slightly revised rendition will return better results for
you:
=IF(G4="","",IF(OR(H4={"",0}),TODAY(),H4))

 

[Don Guillett Excel MVP]

" january 00, 1900" is simply a zero (you can format the cell as
general to see this)
which means H4 probably contains a zero (masked?)

Perhaps this slightly revised rendition will return better results for
you:
=IF(G4="","",IF(OR(H4={"",0}),TODAY(),H4))



- Show quoted text -

Either PRE format or use

=IF(G4="","",IF(H4="",TEXT(NOW(),"mm/dd/yy"),H4))

 

[surveyor kyle]

Either PRE format or use

=IF(G4="","",IF(H4="",TEXT(NOW(),"mm/dd/yy"),H4))- Hide quoted text-

- Show quoted text -

thank you all for your help... it works!!!