Excel Formula: Calculate days remaining between two dates

Author: Sun Last Modified: 2020-07-02

doc calculate overtime pay 4

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.
doc calculate remaining days 2

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.

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.

🤖	Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution \| Generate Code \| Create Custom Formulas \| Analyze Data and Generate Charts \| Invoke Kutools Functions…
	Popular Features: Find, Highlight or Identify Duplicates \| Delete Blank Rows \| Combine Columns or Cells without Losing Data \| Round without Formula ...
	Super VLookup: Multiple Criteria \| Multiple Value \| Across Multi-Sheets \| Fuzzy Lookup...
	Adv. Drop-down List: Easy Drop Down List \| Dependent Drop Down List \| Multi-select Drop Down List...
	Column Manager: Add a Specific Number of Columns \| Move Columns \| Toggle Visibility Status of Hidden Columns \| Compare Columns to Select Same & Different Cells ...
	Featured Features: Grid Focus \| Design View \| Big Formula Bar \| Workbook & Sheet Manager \| Resource Library (Auto Text) \| Date Picker \| Combine Worksheets \| Encrypt/Decrypt Cells \| Send Emails by List \| Super Filter \| Special Filter (filter bold/italic/strikethrough...) ...
	Top 15 Toolsets: 12 Text Tools (Add Text, Remove Characters ...) \| 50+ Chart Types (Gantt Chart ...) \| 40+ Practical Formulas (Calculate age based on birthday ...) \| 19 Insertion Tools (Insert QR Code, Insert Picture from Path ...) \| 12 Conversion Tools (Numbers to Words, Currency Conversion ...) \| 7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...) \| ... and more