QuickLearn
09-05-2002, 08:32 PM
Here is a good example of how to calculate the number of days between two dates. In this example you can see how to simply subtract the two dates.
-- For example, if cell A1 contains the date 6/8/2000 and A2 contains 6/20/2000, the formula =A2-A1 calculates the number of days between these dates (12)
-- Be sure to use number format for the cell where you enter this formula (click Cells on the Format menu, click the Number tab, and then click Number under Category).
-- If you don't format the cell with number format, Excel assumes the result has the same format as the cells used in the calculation, and displays the result as a date instead of a number.
-- For example, if cell A1 contains the date 6/8/2000 and A2 contains 6/20/2000, the formula =A2-A1 calculates the number of days between these dates (12)
-- Be sure to use number format for the cell where you enter this formula (click Cells on the Format menu, click the Number tab, and then click Number under Category).
-- If you don't format the cell with number format, Excel assumes the result has the same format as the cells used in the calculation, and displays the result as a date instead of a number.