Useful Excel Functions: YEARFRAC

I was looking for a way to compare the total years between two dates in decimal format.  My brain immediately goes to the process of how I would do that calculation if I am were writing it in a programming language, but Excel VBA and Excel formulas are a different beast. In Excel, do you use DATEDIF, “sum’ing” with TODAY() or NOW(), or something else? Excel has lots of little functions that do simple date operations

Continue reading