ExcelBanter - Date Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Function (https://www.excelbanter.com/excel-worksheet-functions/80070-date-function.html)

Date Function

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!

Peo Sjoblom

Date Function

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!

Duke Carey

Date Function

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

"Al" wrote:

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!

All times are GMT +1. The time now is 10:26 PM.