Sharp ZAURUS ZR-5000 Specifications download pdf (Page 349)

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.

1 2 ... 344 345 346 347 348 349 350 351 352 353 354 ... 528 529

Comments to this Manuals

No comments