Forum Discussion
Solved
Using DATEIF function
How does one use the DATEIF function to calculate the difference between two dates in different centuries, e.g. 1900s vs. 2000s? What would the formula look like?
Thank you for your assistance, Hans. When I first looked at your example, my recollection is that the example before me didn't appear to span two different centuries. Thanks again!
4 Replies
DATEDIF (not DATEIF) works for dates from 1900 to 9999. For example:
Yes, I understand that. Thank you. BUT, my question was apparently it can't function between two centuries . . . such as between 1990 and 2025?
As you can see in the screenshot in my previous reply, DATEDIF can calculate the difference between dates in the 20th century and 21st century. What exactly is your problem?
