You can create a quick formula that will always calculate the current date on your spreadsheet each time you open it up.

1. Select a cell
2. Type the following formula: =Today()
3. Press Enter
4. Now that cell will always display the current date and can be referenced in other formulas

Tags: Date, Excel 2007, Microsoft Excel

This entry was posted on Sunday, May 3rd, 2009 at 5:17 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.