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 |
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 |
All times are GMT +1. The time now is 03:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com