How to Subtract Dates in Excel 2007

1. Open Excel 2007 and enter the current date in cell A1. Enter another date in cell B1.
2. Highlight cells A1 and B1. Click the 'Home' tab and locate the 'Numbers' group. Change the number format to 'Short Date.'
3. Click cell C1 and enter a subtraction formula. Enter 'A1-B1.' Press the 'Enter' key to see the results.