| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
| How do I protect work sheet against the "Delete" function? | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| Concatenate Function will not work | Excel Discussion (Misc queries) | |||
| GCD Function doesn't work in some cases | Excel Worksheet Functions | |||
Linear Mode
