Q:
# How Do You Subtract Dates in Excel?

**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.

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-
Q:
## How Do You Remove Duplicates in Excel?

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: -
Q:
## How Can You Calculate a Standard Deviation Using Excel?

A: Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is... Full Answer >Filed Under: -
Q:
## What Function Do You Use to List Dates in Excel?

A: Use the DATE function in Excel to list dates. Use the TODAY function to list the current date or the NOW function to list current date and time. Full Answer >Filed Under: -
Q:
## How Do You Make a Simple to-Do List in Excel?

A: Creating a to-do list in Excel 2010 is as simple as clicking on the cells you want to enter data into and typing the data. Users can move to new cells by e... Full Answer >Filed Under: