It's DATE(year,month,day)

=DATE(A1,B1,C1)



--

Regards,

Peo Sjoblom


"Al" wrote in message
...
Hello
A1 =1996
B1= 1
C1=1
A2=date(B1,C1,A1) and outputs 6/19/1906 instead of 1/1/1996
What am I doing wrong? Also if d1=9 what formula would give me 1/1/1996
9:00
Thanks!