Dates before 1900 and Year function

S

smaruzzi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I Modify Julian calendar restriction of 1900 2
Dates before 1900 2
Dates Before 1900 1
dates before 1900 2
Calculating age when person born before 1900 1
How do I find age in years from anniversary date (Age funtion)? 1
calculate with dates before 1-1-1900 3
Month function yields incorrect solution 4

Top