| 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 |
| 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 | |||
Threaded Mode
