Dates are very important in spreadsheets. Not only is it important to add the current date to a spreadsheet when it is created, but much of the data stored in a spreadsheet is date related - such as the date of purchases or expenditures, the length of term of investments, and the date of scientific observations.
There are, therefore, a great many date functions in Excel. Listed below are date function tutorials for Excel 2007. Many of these functions are used to calculate the difference between two dates, but each does it in a slightly different way
Listed here are Excel functions that can be used to count the number of business days between two dates or find the start and end dates of a project given a set number of business days.
These functions can be very useful for planning and when writing proposals to determine the time frame of a project. Several of the functions will automatically remove weekend days from the total. Specific holidays can be omitted as well.
The functions listed below can be used to add the current date to an Excel spreadsheet. Each tutorial includes step by step examples of working with dates in Excel 2007.