Subtracting between two Dates in Excel, Minus Date from Date

Substracting two dates in Excel gives you the no of days between the given dates. You can Substract or Minus two

Dates in Excel using a Today function and the Date function.

The Formula calculates the no of days between the current date and the date specified in the DATE function.

Subtracting between two Dates in Excel, Minus Date from Date


Substracting Dates Example:

=TODAY() – DATE(2016,5,10)

Returns 10 as todays date is 5/20/2016 and date specified is 5/10/2015.

Comments