| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
year formula returning incorrect value
As I understand it, the YEAR formula should return the year to which the
formula relates. I have a date of 4/24/2008 in a cell (let's say it's in cell B2), when I enter the formula (let's say in cell A2) "=YEAR(B2)", the result is 1905 where the result should be 2008. Can someone tell me what I'm missing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returning incorrect value | Excel Discussion (Misc queries) | |||
| Lookup returning incorrect result | Excel Worksheet Functions | |||
| IF function returning incorrect result | Excel Worksheet Functions | |||
| formula returning incorrect blanks | Excel Worksheet Functions | |||
| formula returning incorrect blanks | Excel Discussion (Misc queries) | |||
Threaded Mode
