How to Count Ages in Days

You can count ages in different units such as years, months, days and hours, etc. depending on the situation. In this post, we will figure out how to count ages in days.

Example: In the following example, the start date is in column A, and the end date is in column B.

Formula 1: To calculate the age in days between the start date and the end date.

The easy method is to use the end dates minus the start dates.

=B2 - A2

For example, there are 19 days between "Mar 08, 2015" and "Mar 27, 2015".

Formula 2: Another method is to use the DATEDIF function, which can return the number of days, months, or years between the two dates.

=DATEDIF(A2, B2, "D")

"D" is the calculation type for the number of days, and please check below for the complete calculation types.

  • "Y": The number of years;
  • "M": The number of months;
  • "D": The number of days;
  • "MD": The difference when ignoring the years and months;
  • "YM": The difference when missing the years and days;
  • "YD": The difference when ignoring the year.

Leave a Reply