DatesFree · No signup

Excel Date Calculator

Get the answer and the formula. Count calendar days, exclude weekends, work out an age, or find the date 30 working days from now — all in one place.

Runs in your browserUpdated October 25, 2026Calendar days, workdays, age and deadlines · Formula included

The short answer

An Excel date calculator finds the difference between two dates in days, weeks, months or years, and returns the matching Excel formula. It can exclude weekends with NETWORKDAYS, add working days with WORKDAY, and calculate age with DATEDIF — including the exact syntax to paste into your sheet.

Start dateEnd date

Count working days only (exclude weekends)

Calendar days

End minus start

Inclusive days

Counts both dates

Weeks

4.3

Decimal weeks

Full months

Completed months

=B2-A2

Calendar days. Format the result as a number, not a date.

=NETWORKDAYS(A2,B2)

Working days including both dates. Add a holidays range as the third argument.

=DATEDIF(A2,B2,"m")

Completed months between the two dates.

=DATEDIF(A2,B2,"y")

Completed years between the two dates.

Calculations use calendar dates only — time of day is ignored. Excel's date system starts on 1 January 1900, so dates before that cannot be used in a workbook.

How to use it

1Choose the calculation: difference, add days, age or deadline countdown.
2Enter dates in the date pickers or as YYYY-MM-DD text.
3Tick “working days only” to exclude weekends.
4Copy the Excel formula shown with the answer and paste it into your sheet.

Questions about the date calculator

How do I calculate days between two dates in Excel?

Subtract the start date from the end date: =B2-A2, then format the result as a number. For inclusive counting add 1: =B2-A2+1. For working days only, use =NETWORKDAYS(A2,B2).

Why does my Excel date formula return a number like 45678?

Excel stores dates as serial numbers. A result showing 45678 means the cell is formatted as General or Number. Apply a Date format (Ctrl+1 → Date) to display it as a date.

How do I exclude weekends and holidays?

Use NETWORKDAYS(start, end, holidays) to count working days, or WORKDAY(start, days, holidays) to find a future working date. Put your holiday dates in a separate range and reference it as the third argument.

How do I calculate age from a birthdate?

Use =DATEDIF(A2,TODAY(),"Y") for completed years. For years, months and days use three DATEDIF calls with "Y", "YM" and "MD". DATEDIF still works in every Excel version even though it is not in the function list.

Need it done for you?

Date logic breaking your deadline model?

We build deadline trackers, ageing reports and working-day models that update themselves — with the formulas documented for your submission.

Get a fixed quote Ask on WhatsApp See pricing →

From $15/hr
Fixed quote before work starts
Free minor revisions
Human experts, not AI files

Related free tools

All tools →

Formula ExplainerPaste any Excel formula and get a plain-English explanation of every function, range and nested step.Open tool →Formula CheckerCheck any Excel formula for syntax errors, wrong argument counts, approximate-match traps and #REF! errors.Open tool →Formula GeneratorBuild accurate Excel formulas from plain choices: SUMIF, SUMIFS, COUNTIF, IF, IFERROR, TEXTJOIN, INDEX MATCH and more.Open tool →

Keep reading