| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does excel 2007 subtract 2009 from 2015 = 1900?
have tried different formats for the dates, always comes up the same. have
formated in date/time format, =(YEAR(10/16/2015)-YEAR(05/11/2009))*12+MONTH(10/16/2015)-MONTH(05/11/2009)= 1/0/1900.....what is wrong here? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 | Excel Discussion (Misc queries) | |||
| =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why? | Excel Worksheet Functions | |||
| How do I determine who will be age 55 by 12/31/2007 and 6/30/2009? | Excel Worksheet Functions | |||
| Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009? | Excel Worksheet Functions | |||
| How do I subtract today's date from one before 1900? | Excel Discussion (Misc queries) | |||
Threaded Mode
