The following function displays the current date in a cell:

=TODAY()

You can also display the date combined with text. The formula that follows, for example, displays text, such as Today is Monday, April 9, 2007.

=”Today is “&TEXT(TODAY(),”dddd, mmmm d, yyyy”)

It’s important to understand that the TODAY function is updated whenever the worksheet is calculated. For example, if you enter either of the preceding formulas into a worksheet, the formulas display the current date. But when you open the workbook tomorrow, they will display the current date (not the date when you entered the formula).

To enter a date stamp into a cell, press Ctrl+; (semicolon). This action enters the date directly into the cell and does not use a formula. Therefore, the date will not change.

• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...
• How Far Do Mortage Rates Have to Fall for Refinancing to Make 'Cents?' The answer is complex and involves a number of variables: current principal amount, current interest rate, closing costs, among others....
• The Best Way to Retire Early There are a lot of retirement calculators out there offering to calculate how much you'll need in retirement. I don't think...
• Major Prosper Update -- Just in Time for Prosper Days  Prosper's First Anniversary First of all, let's take a moment to celebrate. On Feb 5, Prosper turned one year old....