# Calculating Number of Days, Weeks, Months and Years between Dates - MS Excel

#### by Rekha[ Edit ] 2010-10-28 12:03:27

**Calculating Number of Days, Weeks, Months and Years between Dates - MS Excel**
Calculating the difference between each pair of dates listed in columns

A & B.

To calculate the difference in days, use the DATEDIF function as shown in the following formula:

**=DATEDIF(A2,B2,"d")**
To calculate the difference in weeks, use the INT function as shown in the following formula:

**=INT((B2-A2)/7)**
To calculate the difference in months, use the DATEDIF function as shown in the following formula:

**=DATEDIF(A2,B2,"m")**
To calculate the difference in years, use one of the following two solutions:

Use the DATEDIF function as shown in the following formula:

**=DATEDIF(A2,B2,"y")**
OR

Use the YEAR, MONTH, AND, and DAY functions as shown in the following formula:

**=YEAR(B2)-YEAR(A2)-(MONTH(B2)**
To calculate the number of months over years, use the DATEDIF function as shown in the following formula:

**=DATEDIF(A2,B2,"ym")**
To calculate the number of days over years, use the DATEDIF function as shown in the following formula:

**=DATEDIF(A2,B2,"yd")**