Getting Error when calculating date value

[boccuz]

Hello,

I am trying to calculate the date value and are getting errors. I am not sure why. Any help is greatly appreciated. Attached is a sample spreadsheet showing what I am attempting to do.

Thanks in advanced.


28985

[Paul_Hossler]

Try



=DATE(YEAR(A2), MONTH(A2),DAY(A2))

[arnelgp]

=DATEVALUE(TEXT(A2,"mm/dd/yyyy"))

[boccuz]

Thanks Paul and Arn. Got to work appreciate the help!