The examples in rows three to five extract information related to the current date - such as the current year, month, or day - by using the output of the TODAY function in cell A2 as the argument for the YEAR, MONTH, and DAY functions.The TODAY function can also be used to calculate the interval between two dates, such as the number of days or years as shown in rows six and seven in the image above.

It obtains this information on the current date by reading the computer's clock.

Options for entering the TODAY function include: Since the TODAY function does not have any arguments that can be entered manually, many people opt to just type in the function rather than use the dialog box.

This chapter takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.

In This Chapter Understanding Formula Basics Understanding Operator Precedence Controlling Worksheet Calculation Copying and Moving Formulas Displaying Worksheet Formulas Converting a Formula to a Value Working with Range Names in Formulas Working with Links in Formulas Formatting Numbers, Dates, and Times that perform calculations and produce results.

But if I edit D2 and I press SPACE (so I modify the D2 VALUE ) Calc can calculate the good value.

F9 works but I think I should not have to use F9 all the time.The syntax for the TODAY function is: The function does not have any arguments that can be set manually.TODAY uses the computer's serial date - which stores the current date and time as a number - as an argument.Table 3.4 summarizes the operators you can use in reference formulas.The TODAY function can be used adding the current date to a worksheet as shown in row two of the image above and in date calculations -- rows three to seven above.This is handy if you have a very long formula because it enables you to “break up” the formula so that it appears on multiple lines.

Tags: , ,