Year function does not work

A

aeronaut

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
 
C

Chip Pearson

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
 
A

aeronaut

I thank you. This fixed it.
Andras

Chip Pearson said:
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
Click to expand...
 
Top