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:
No comments:
Post a Comment