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!