Subtracting between two Dates in Excel, Minus Date from Date

59
188
Subtracting-between-two-Dates-in-Excel-Minus-Date-from-Date-ExcelBlackBook.com

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-ExcelBlackBook.com

Substracting Dates Example:

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

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