How can you calculate the number of days, months or years between two dates?
- Your age in days, months and years
- An employee’s length of service
- Length of a project
Let me introduce you to DATEDIF (i.e. Date difference), a very useful, but hidden function used to calculate the difference between two dates in the number of days, months or years. Continue reading