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!
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?
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!