How to Calculate Number of Days in Excel?

Use `=B1-A1` to get the number of days between two dates

Use `=DATEDIF(A1,B1,”d”)` to calculate days between two dates

Use `=TODAY()-A1` to calculate days from a date to today

Use `=B1-A1+1` to include both start and end dates

Use `=NETWORKDAYS(A1,B1)` to count weekdays only

Use `=NETWORKDAYS.INTL(A1,B1,1)` to count weekdays with a custom weekend pattern

Format the result cell as Number if Excel displays a date instead of a day count

Suggested for You

Trending Today