Have you ever wanted to subtract one date from another? Or find out how many workdays until vacation? Or maybe you need to figure out a project end date. You can do all of this and more by using date functions in Excel formulas.
As long as you type a date in a format that Excel recognizes: 8/22/2011, 22-August-2011, or August 22, 2011, for example, Excel will interpret the date as a serial number, and you can use formulas to find important dates. For example, you can then use formulas to subtract one date from another.
If you’re not sure whether you typed a date in a format that Excel recognizes, do the following:
- Go to the Home tab on the ribbon.
- Click the arrow on the Number group, select Date, and then pick a format.
To help you learn more about dates and formulas, my colleague Judi Hurlock has created this excellent training course: Figure out dates by using formulas in Excel 2010.
So be sure to check out the training course — it’s free — and let us know what you think.