Forum Discussion
Solved
How to calculate time between two dates. What replaces datedif?
I need to calculate age in years between two dates. Help says use datedif, but the function does not appear in excel! I know there is a way to create a function that does this, but I haven't the alge...
In addition, there is no tooltip for DATEDIF(). You shall type it on your own, Excel shows nothing while you are entering function.
Alternatively you may use YEARFRAC function (microsoft.com)
Lisainnj Which version of Excel are you using, on which platform? It is available in most versions, but not well documented in some of them.
Let's say you have dates in A2 and B2. Try entering =DATEDIF(A2,B2,"y") in another cell.
This works -- if you follow exactly the correct syntax!