| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YEAR function issue
Found the problem. I had the result cell formatted to YYYY
"Barb Reinhardt" wrote: I have the following formula =IF(ISBLANK($O8),NA(),YEAR($O8)) $O8: 12/28/2005 which is interpreted by the formula as 38714 I'm getting 1905 as a result. Suggestions? Thanks, Barb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use year function? | Excel Discussion (Misc queries) | |||
| How to use year function? | Excel Discussion (Misc queries) | |||
| How to use year function? | Excel Discussion (Misc queries) | |||
| How to use year function? | Excel Discussion (Misc queries) | |||
| Datevlaue function/ day/month/year function | Excel Worksheet Functions | |||
Threaded Mode
