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.