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.
Excel 2007 NOW Function
Excel Date Function Tutorials
The NOW function will add both the current time and date to a spreadsheet. You can choose to format the function to show either the current time or date or both. This tutorial includes an example of using the NOW function in Excel 2007.
Excel 2007 TODAY Function
Excel Date Function Tutorials
The TODAY function adds the current date to a spreadsheet in the default format. You can use the various date format options to change the appearance of the date. This tutorial includes an example of using the TODAY function in Excel 2007.
Excel 2007 DATE Function
Excel Date Function Tutorials
The DATE function can be used to add a date to a spreadsheet. The date added does not have to be the current date. It can also be used to ensure that when dates are added to a spreadsheet they are formatted as text which prevents them from being used in formulas and other functions. This tutorial includes an example of using the DATE function in Excel 2007.
