86
TODAY() Returns the current date (from the
system clock) as a serial number. If the
cell is formatted with the date/time
format DD-MMM-YY, this serial number
is displayed as the current date.
Example: TODAY() appears as
03-Sep-96 when the date is Septem-
ber 3, 1996 and the cell is formatted
to display the date.
DATE(
year
,
month
,
day
)
Returns a serial number correspond-
ing to the date, where
year
is a 2- or
4-digit integer (e.g. 1996 or 96),
month
is an integer from 1 to 12, and
day
is an integer from 1 to 31.
Example: DATE(1996, 3, 22) displays
22-Mar-96.
DATE(1996, 3, 22)+1 displays 23-Mar-
96.
NOTE
When you enter a year after 2000, be
sure to enter it in four digits.
SUM (
values...
) Returns the sum of all the
values
in
list of arguments.
Example: SUM (23,293,-97,63)
returns 282. SUM (A1:A4) returns the
sum of
values
in cells A1 to A4.
Date/time functions
All time functions use a 24-hour clock.
The spreadsheets represent date and time information
in cells as “serial numbers.”
Creating date and time representations
There are six functions for creating date and time
representations:
NOW() Returns current date or time. If the cell
is formatted with the date/time format
HH:MM:SS, this serial number is
displayed as the current time (from the
system clock).
Example: NOW() appears as
09:27:45 when the time is 09:27:45
a.m. and the cell is formatted to
display the time.
To Next Page
Loading...
