Home » Posts

Calculate days remaining

To calculate the days remaining from one date to another, you can use a simple formula that subtracts the earlier date from the later date. In the example shown, the formula in D5 is: =C5-B5

April 14, 2025 · 1 min · 51 words · Edward Long

Table of Contents

Explanation

Dates in Excel are just serial numbersthat begin on January 1, 1900.

Remaining workdays

To count remaining workdays, see theNETWORKDAYS functionand the examplehere.

The TODAY function takes no arguments.

Excel formula: Get days between dates

you’re able to format the value returned by TODAY with a datenumber format.

If you need current date and time, use…

Excel formula: Get workdays between dates

Excel formula: Calculate days open

Excel TODAY function

Explanation#

Remaining workdays#

Explanation

Remaining workdays