Excel datedif formula

Useful excelformula that is hidden from the common gui, but present in all version of excel.

To compare a date to today

=DATEDIF(A1,TODAY(),"d")

Outputs difference in days. Can also return in complete months, years and then some.

D	Number of days
M	Number of complete months
Y	Number of complete years
YD	Number of days excluding years
MD	Number of days excluding months and years
YM	Number of months excluding years

Note that on Swedish systems formulas look like this instead:

Comma is replaced by semicolon for some reason.

References:

http://excel.datedif.com/

http://stackoverflow.com/questions/10928586/excel-calculate-the-date-difference-from-today-from-a-cell-of-7-6-2012-102642