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
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/05/03/learn-the-ins-and-outs-of-dates-and-formulas-in-this-free-training-course.aspx
Posted
May 03 2011, 02:03 PM
by
Microsoft Excel