Excel Date Time Difference Formulas
Excel date and time difference formulas with examples. Calculate days, hours, minutes, months, years, business days, and more using simple Excel formulas.
Date rule:
Cells must contain real Excel dates, not text.
Recommended format: 01-Jan-2025
Check with: =ISNUMBER(A2)
Click a case to reveal the formula and example.
=B2 - A2
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 01-Jan-2025 | 10-Jan-2025 |
|---|
Result: 9 days
=(B2 - A2) * 24
| A | B |
|---|
| 1 | StartTime | EndTime |
|---|
| 2 | 01-Jan-2025 08:00 | 02-Jan-2025 14:00 |
|---|
Result: 30 hours
=(B2 - A2) * 1440
| A | B |
|---|
| 1 | StartTime | EndTime |
|---|
| 2 | 01-Jan-2025 09:00 | 01-Jan-2025 12:00 |
|---|
Result: 180 minutes
=DATEDIF(A2,B2,"Y") & " years "
& DATEDIF(A2,B2,"YM") & " months "
& DATEDIF(A2,B2,"MD") & " days "
& HOUR(MOD(B2-A2,1)) & " hours "
& MINUTE(MOD(B2-A2,1)) & " minutes "
& SECOND(MOD(B2-A2,1)) & " seconds"
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 15-Mar-2020 18:25:10 | 20-Jun-2022 10:35:15 |
|---|
Result: 2 years 3 months 5 days 16 hours 10 minutes 5 seconds
=DATEDIF(A2,B2,"M")
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 01-Jan-2024 | 01-Apr-2025 |
|---|
Result: 15 months
=NETWORKDAYS(A2,B2)
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 01-Jan-2025 | 10-Jan-2025 |
|---|
Result: 8 business days
=NETWORKDAYS(A2,B2,E2:E3)
| A | B | E |
|---|
| 1 | Start | End | Holidays |
|---|
| 2 | 01-Jan-2025 | 10-Jan-2025 | 01-Jan-2025 |
|---|
| 3 | | | 06-Jan-2025 |
|---|
Result: 6 business days
=NETWORKDAYS(A2,B2) * 8
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 01-Jan-2025 | 05-Jan-2025 |
|---|
Result: 24 hours
=TEXT(B2-A2,"h:mm")
| A | B |
|---|
| 1 | StartTime | EndTime |
|---|
| 2 | 01-Jan-2025 09:30 | 01-Jan-2025 15:00 |
|---|
Result: 5:30
=IF(B2<A2,"Invalid date",B2-A2)
| A | B |
|---|
| 1 | StartDate | EndDate |
|---|
| 2 | 10-Jan-2025 | 01-Jan-2025 |
|---|
Result: Invalid date