Return days remaining between two dates

This tutorial shows how to calculate the remaining days between two dates by using a basic arithmetic formula

EXCEL FORMULA 1. Return days remaining between two dates

EXCEL

Return days remaining between two dates

=C5-B5
GENERIC FORMULA

=end_date-start_date

ARGUMENTS
end_date: The later of the two dates.
start_date: The earlier of the two dates.

EXPLANATION
This tutorial shows how to calculate the remaining days between two dates by using a basic arithmetic formula that subtracts an earlier date from a later date.

RELATED TOPICS

Related Topic Description Related Topic and Description
Return date overlap in days How to return the number of days that overlap between two date ranges
Return days remaining as of today How to calculate the remaining days as of today