# Excel Tips – Number of Days, Weeks, Months & Years between Dates

Calculating the difference between each pair of dates listed in columns

A & B.

Solution:

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”)

January 2021
M T W T F S S
123
45678910
11121314151617
18192021222324
25262728293031