if statement with dates

S

Sanford Lefkowitz

I would like to write a statement like:
If(a1>0,1/1/2004)
where 1/1/2004 is interpreted as a date.
EXCEL is doing the arithemetic and giving me a decimal.
I could write 1/1/2004 as its numeric offset and write something like:
if(a1>0,37987), but that is rather awkward.

What else can I do?

TIA,
Sanford
 
D

dcronje

would it help if you used

=IF(A1>0,Date(2004,01,01),0)

Date function is used as Date(Y,M,D
 
Top