| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates before 1900 and Year function
I need to calculate the difference between two dates, one of which could be
before 1900. The YEAR function doesn't seem to work on dates earlier than 1900. What's the best and most efficient way to detect a date is before 1900, extract the year and use that number in a subtraction? More specifically, I'm interested in calculating the age of several passed away VIPs of human mankind. Thanks, Stefano |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates before 1900 and Year function
See this:
http://j-walk.com/ss/excel/usertips/tip028.htm -- Biff Microsoft Excel MVP "smaruzzi" wrote in message ... I need to calculate the difference between two dates, one of which could be before 1900. The YEAR function doesn't seem to work on dates earlier than 1900. What's the best and most efficient way to detect a date is before 1900, extract the year and use that number in a subtraction? More specifically, I'm interested in calculating the age of several passed away VIPs of human mankind. Thanks, Stefano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why? | Excel Worksheet Functions | |||
| Incorrect Excel date 1900 is not a leap year 1/1/1901 < 367 | Excel Discussion (Misc queries) | |||
| FORMAT A CELL TO USE MO/DATE WITH NO YEAR:,DISPLAYS 1900? | Excel Discussion (Misc queries) | |||
| 1900 not a leap year | Excel Worksheet Functions | |||
| is 1900 a Leap Year? | Excel Discussion (Misc queries) | |||
Linear Mode
