Excel Dates for Beginners: Calculate Days and Handle Deadlines

Dates can look like text while behaving like numbers, or look like dates while still being text. Understanding the difference makes deadline calculations much easier. In this lesson, you will create clear dates, calculate elapsed days and test a simple due-date rule.

Before you start: Use a new practice workbook. The names and figures below are fictional. Enter the headers in row 1 and the first record in row 2 unless a step says otherwise. Formulas use English function names and commas; your regional settings may require semicolons instead. Save a copy before experimenting.

Create dates without guessing the entry format

Type Task in A1, Start in B1 and Due in C1. Enter these values using DATE formulas so the day and month cannot be confused by regional settings:

DATE takes year, month and day in that order. Apply a readable date format to B2:C4. A display such as 01-Oct-2026 makes the month clear. If a cell displays a number instead, it may contain a valid date with a General or Number format.

Excel dates use serial numbers for day-based calculations. Formatting changes how those numbers appear. It does not magically convert every imported date-like text string into a valid date value.

Subtract dates to count elapsed days

Put Elapsed days in D1. In D2 enter =C2-B2 and copy down. Format D2:D4 as General or Number. The answers are 4, 7 and 0.

This is elapsed-day difference. It is not an inclusive count of every calendar date touched. From 1 October to 5 October, four days elapse. If your rule counts both the start and due dates as included days, use =C2-B2+1, which gives 5 for the first task.

Neither definition is automatically correct for every report. Write the definition beside the column. Working days are another question again; ordinary subtraction includes weekends and holidays.

Extract useful date parts

For the first start date, =YEAR(B2) returns 2026, =MONTH(B2) returns 10 and =DAY(B2) returns 1. These functions help classify or check dates without manually splitting the displayed text.

Avoid grouping records by month number alone when your data spans several years. October 2026 and October 2027 both have month number 10. You need the year as well, or a month-start date such as =DATE(YEAR(B2),MONTH(B2),1) to keep the periods distinct.

Test a deadline rule with a fixed date

In F1 enter As-of date and in G1 enter =DATE(2026,10,6). In E1 type Status. In E2 use =IF(C2<$G$1,"Past due","Not past due") and fill down.

Draft is Past due. Review and Publish are Not past due. This rule treats a task due on the as-of date as not yet past due. If your rule says it becomes late at the start of its due date, the comparison would differ. Boundary definitions matter.

A fixed as-of date makes this practice reproducible. For a live tracker, TODAY() returns the current date when Excel recalculates. That also means a saved workbook's labels can change as time passes. Use a fixed reporting date when a historical snapshot must stay stable.

Look for hidden time values and missing dates

An imported timestamp can include a fractional part representing time. A cell displayed as a date may still contain hours and minutes. Subtraction may then return a fractional number of days. Decide whether to preserve that detail or deliberately work with date-only values.

Do not treat a blank due date as a real deadline. A defensive status formula can start with =IF(C2="","Missing due date",IF(C2<$G$1,"Past due","Not past due")). This still assumes any nonblank input is a valid date; inspect imported values before trusting the result.

Try it yourself

Add a task with a start of 28 October 2026 and a due date of 2 November 2026. Use DATE for both entries. Find the elapsed and inclusive day counts. With an as-of date of 3 November 2026, what should its status be?

Keep learning: Return to the Excel learning path to choose your next lesson.