Excel Formula: Calculate days remaining between two dates
Here, this tutorial provides a formula to quickly calculate the left days between two dates.
If you want to follow along with this tutorial, please download the example spreadsheet.
Generic formula:
| End_date-Start_date |
Arguments
| Start_date: the start date in the date range. |
| End_date: the end date in date range. |
Return value
The formula returns the remaining days in a number format.
How this formula work
Supposing calculate the left days between dates in B3 and C3, please use below formula:
| =C3-B3 |
Press Enter key to get the first result, then drag fill handle to get all remaining days between each date range.
Relative Formulas
- Calculate Overtime Pay
In this tutorial, it shows a timesheet to list the working hours, and provides a formula to calculate the overtime pay. - Assign Points Based On Late Time
This tutorial provides a clear guide on how to use the IF function to assign points on late time in excel. - Add Minutes To Time
This tutorial provides formulas and explains how to add minutes to time in Excel. - Excel Formula: Add Months To Date
It introduces formulas to add months to a given date in Excel, and explains how the formulas work.
Relative Functions
- Excel IF Function
Test for specified conditions, then returns the corresponding values - Excel VALUE Function
Convert text to number. - Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date. - Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date - Excel YEAR Function
The YEAR function returns the year based on the given date in a 4-digit serial number format.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
