1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Subtract Dates in Excel

Functions in Excel that can be Used to Subtract Two Dates

By

There are a number of functions in Excel that can be used to subtract dates. Which one you use depends on whether you want to subtract days, months, or years. The following articles include examples of subtracting two dates in Excel using the different date functions.

Excel DATEDIF Function

Subtract Dates in Excel: DATEDIF Function
Subtract Dates in Excel: DATEDIF Function
The DATEDIF function is perhaps the most versatile of the functions capable of subtracting two dates. It can be used to subtract the number of days, months, or years between two dates even if they are in different years.

Excel DAY Function

Subtract Dates in Excel: DAY Function
Subtract Dates in Excel: DAY Function
The DAY function can be used to find the number of days between two dates. However, the function excludes the month and year portions of a date, therefore, it will not correctly subtract two dates that are in different months or years.

Excel MONTH Function

Subtract Dates in Excel: MONTH Function
Subtract Dates in Excel: MONTH Function
The MONTH function can be used to find the number of days between two dates. However, the function excludes the year portion of a date, therefore, it will not correctly subtract two dates that are in different years.

Excel YEAR Function

Subtract Dates in Excel: YEAR Function
Subtract Dates in Excel: YEAR Function
The YEAR function can be used to subtract two dates to find the number of years between the dates.
Top Related Searches
  • functions in excel
  • datedif
  • ©2014 About.com. All rights reserved.