Date Function

A

Al

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

Duke Carey

the Date() function requires Year, Month, Date, so your formula should be

=date(A1,B1,C1)

If you want the 9:00 added (AM?), use

=date(A1,B1,C1)+9/24
 
Top