excel time stamp

  • Thread starter Thread starter surveyor kyle
  • Start date Start date
S

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.
 
" 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))
 
" 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 -
Click to expand...

Either PRE format or use

=IF(G4="","",IF(H4="",TEXT(NOW(),"mm/dd/yy"),H4))
 
Either PRE format or use

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

- Show quoted text -
Click to expand...

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