Thread: Dates before 1900 and Year function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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 With QuoteReply With Quote