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.

Substracting Dates Example:

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

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