DAYS Function

Summary

The DAYS function returns the number of calendar days between two dates. It gives you a straight day difference, so weekends and holidays still count like any other day.

This makes DAYS useful when you want elapsed time in the simplest sense. Shipping time, storage fees, countdowns, and calendar-based thresholds are all common examples.

DAYS is best used when the worksheet only needs the straight calendar gap between two dates. It keeps the calculation simple and readable, which is helpful for elapsed-time checks, due-date comparisons, and quick reports where weekends and custom calendars do not need special handling.

Syntax

=DAYS(end_date, start_date)

DAYS takes the end date first and the start date second. That order is easy to mix up, especially if you are used to subtracting cells directly.

If both values are valid Excel dates, DAYS returns the difference in whole calendar days. It does not remove Saturdays, Sundays, or holidays.

Arguments

• end_date - The date you want to count up to.
• start_date - The date you want to count from.

If either input is not recognized as a real date, Excel can return an error.

DAYS vs Other Date Differences

DAYS is only one way to measure time between dates. The right choice depends on what kind of day count you need.

A simple way to think about it is this: use DAYS when you want the calendar gap and want the formula to say that intention clearly.

Using DAYS

One common use for DAYS is any report where every day matters equally. If an item sat in storage for 12 days, or a deadline is 5 days away, DAYS gives you that number directly.

It also helps when you want a clearer formula than plain subtraction. A formula like =DAYS(B2,B1) is a little easier to read later because it immediately tells you that the calculation is about dates.

• Use DAYS for countdowns and elapsed calendar time.
• Use it when weekends should still be included in the result.
• Reverse the arguments on purpose only if you want to allow negative results.

That negative result can actually be useful. It tells you a target date has already passed instead of hiding that situation behind a positive number.

Example 1 - Count the Days Between Two Dates

This is the basic use of DAYS: count the calendar gap between a start date and an end date.

=DAYS(B2, B1)

If B1 is January 1 and B2 is January 15, the result is 14.

Example 2 - Count Down from Today

DAYS also works well with TODAY() when you want a live countdown.

=DAYS(B2, TODAY())

This updates automatically whenever the workbook recalculates.

Example 3 - Reverse the Order on Purpose

If you flip the arguments, the result changes sign. That is useful when overdue items should show as negative numbers.

=DAYS(B1, B2)

A negative result means the first date is earlier than the second date.

Example 4 - Use the Result in Another Calculation

Because the result is numeric, you can plug it straight into rate-based formulas.

=DAYS(B2, B1) * 150

This is a simple pattern for storage fees, penalties, or daily charges.

Conclusion Recap

DAYS is a good fit when you need the plain calendar difference between two dates and nothing more. It stays simple, readable, and easy to reuse in larger formulas.

• Core job: DAYS returns the number of calendar days between two dates.
• Main rule: The function uses end date first, then start date.
• Key difference: It does not remove weekends or holidays.
• Useful signal: Negative results can show that a deadline has already passed.
• Practical use: It works well in countdowns, storage math, and elapsed-time checks.