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.
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.
Comments
Post a Comment