Year function does not work
 

I have the following in cells U6 and V6:

Cell U6 V6
Contents 1/7/1999 =YEAR(U6)

Cell V6 should return 1999, but it returns 6/21/1905 instead.
I thank for your help.

Andras

You need to format cell V6 as General not a date. Dates are
stored as the number of days since 0-Jan-1900, and the date
6/21/1905 is 1999 days since 0-Jan-1900.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"aeronaut" wrote in message
...
I have the following in cells U6 and V6:

Cell U6 V6
Contents 1/7/1999 =YEAR(U6)

Cell V6 should return 1999, but it returns 6/21/1905 instead.
I thank for your help.

Andras

I thank you. This fixed it.
Andras

"Chip Pearson" wrote:

You need to format cell V6 as General not a date. Dates are
stored as the number of days since 0-Jan-1900, and the date
6/21/1905 is 1999 days since 0-Jan-1900.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"aeronaut" wrote in message
...
I have the following in cells U6 and V6:

Cell U6 V6
Contents 1/7/1999 =YEAR(U6)

Cell V6 should return 1999, but it returns 6/21/1905 instead.
I thank for your help.

Andras