Tag Archives: DATEDIF Function

Excel's Secret DATEDIF Function

How to Calculate Age and Other Time Periods with Excel’s Secret DATEDIF Function

By Marie McCooey

How can you calculate the number of days, months or years between two dates?

For example:

  • 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