Calc Guide

Syntax Description
NOW() Returns the computer system date and time.
The value is updated when your document
recalculates. NOW is a function without
arguments.
SECOND(number) Returns the second, as an integer, for the
given time value. Number is a time value.
TIME(hour; minute;
second)
Returns the current time value from values for
hours, minutes and seconds. This function can
be used to convert a time based on these three
elements to a decimal time value. Hour,
minute and second must all be integers.
TIMEVALUE(text)
Returns the internal time number from a text
enclosed by quotes in a time entry format. The
internal number indicated as a decimal is the
result of the date system used under OOo to
calculate date entries.
TODAY() Returns the current computer system date.
The value is updated when your document
recalculates. TODAY is a function without
arguments.
WEEKDAY(number; type) Returns the day of the week for the given
number (date value). The day is returned as
an integer based on the type. Type determines
the type of calculation: type = 1 (default), the
weekdays are counted starting from Sunday
(Monday = 0); type = 2, the weekdays are
counted starting from Monday (Monday = 1);
type = 3, the weekdays are counted starting
from Monday (Monday = 0).
WEEKNUM(number;
mode)
Calculates the number of the calendar week of
the year for the internal date number. Mode
sets the start of the week and the calculation
type: 1 = Sunday, 2 = Monday.
WEEKNUM_ADD(date;
return_type)
Calculates the calendar week of the year for a
Date. Date is the date within the calendar
week. Return_type sets the start of the week
and the calculation type: 1 = Sunday, 2 =
Monday.
WEEKS(start_date;
end_date; type)
Calculates the difference in weeks between
two dates, start_date and end_date. Type is
one of two possible values, 0 (interval) or 1 (in
numbers of weeks).
Appendix B Description of Functions 461