Q:

# How do you subtract dates in excel?

A:

### Quick Answer

To subtract dates in Excel, simply enter the following formula: "=A3-A2", assuming that cells A3 and A2 contain the dates that need to be subtracted. This will output the difference between the two dates, expressed in days.

Continue Reading

## Keep Learning

### Full Answer

Excel also allows one to compute this difference expressed in workdays, months or years. The expression "=NETWORKDAYS(A2,A3)" will calculate the number of working days between two dates. The difference in months will be given by the formula: "=MONTH(A3)-MONTH(A2)", if the two dates fall in the same year. If they are more than a year apart, the expression needs to be changed to: "=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)". Finally, the difference in years can be computed using the following formula: "=YEAR(A3)-YEAR(A2)".

Learn more about Software
Sources:

## Related Questions

• A: To remove duplicates in Excel, select the cells that include the duplicates, click on the Data tab, and select the Remove Duplicates option. Click OK on th... Full Answer >
Filed Under:
• A: To merge cells in Excel, simply highlight the cells you want to merge, right-click, and select Format Cells. Next, select the Alignment tab, and check the ... Full Answer >
Filed Under:
• A: To create a spreadsheet, open Excel and begin entering information into the cells. Save the spreadsheet to the hard drive by clicking File and Save. In Exc... Full Answer >
Filed Under:
• A: To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows... Full Answer >
Filed Under:
PEOPLE SEARCH FOR