Calculate the difference between two dates

Use the DATEDIF function when you want to calculate the difference between two dates.

Syntax

DATEDIF(start_date,end_date,unit)

Difference in years

1. Put a start date in a cell, and an end date in another.
Cell

2. Type a formula.

Formula

3. Press Enter to get the result.

Enter to get results

Difference in months

1.Type a formula.

Formula

2. Press Enter to get the result.

Results

Difference in days

1.Type a formula.

Formula

2. Press Enter to get the result.

Results