Page 13 of 16PREVNEXT

Figure out dates by using formulas

Using the TODAY function

The TODAY function has no arguments.

The TODAY function is unusual; it's one of the few Excel functions that doesn't require any argument, although it does require opening and closing parentheses: =TODAY()

TODAY inserts the current date, which is updated each time a workbook is opened or recalculated.

Just for fun, you could use the TODAY function to find out from today's date how many days old you are. You'll see how to do that calculation in the practice session.

Note     The functions in this lesson are just a few of Excel's many, many functions. In "Find functions and enter arguments," you can learn how to find other functions, which you can use for all sorts of calculations.

Page 13 of 16PREVNEXT