excel time stamp

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.
 
M

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))
 
D

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

Either PRE format or use

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

surveyor kyle

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!!!
 
R

Ron Rosenfeld

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

You could custom format the cell containing the formula as:

mmmm dd, yyyy;;
 
Top