Formulas and Functions

Table Of Contents

Chapter 3 Date and Time Functions 55

Related Topics

For related functions and additional information, see:

“DATEDIF” on page 45

“DAYS360” on page 49

“WORKDAY” on page 61

“YEARFRAC” on page 63

“Listing of Date and Time Functions” on page 42

“Value Types” on page 36

“The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

NOW

The NOW function returns the current date/time value from the system clock.

NOW()

Usage Notes

The NOW function does not have any arguments. However, you must include the Â

parentheses: =NOW().

Example

=NOW() returns October 4, 2008 10:47 am, if your le is updated on October 4, 2008, at 10:47 a.m.