Calc Guide

Syntax Description
DAYSINYEAR(date) Calculates the number of days in the year of
the given date.
EASTERSUNDAY(integer) Returns the date of Easter Sunday for the
entered year. Year is an integer between 1583
and 9956 or 0 and 99.
EDATE(start_date;
months)
The result is a date a number of Months away
from the given Start_date. Only months are
considered; days are not used for calculation.
Months is the number of months.
EOMONTH(start_date;
months)
Returns the date of the last day of a month
which falls Months away from the given
Start_date. Months is the number of months
before (negative) or after (positive) the start
date.
HOUR(number) Returns the hour, as an integer, for the given
time value. Number is a time value.
ISLEAPYEAR(date)
Determines whether a given date falls within a
leap year. Returns either 1 (TRUE) or 0
(FALSE).
MINUTE(number) Returns the minute, as an integer, for the
given time value. Number is a time value.
MONTH(number) Returns the month, as an integer, for the given
date value. Number is a time value.
MONTHS(start_date;
end_date; type)
Calculates the difference, in months, between
two date values. Date_1 is the start (earlier)
date. Date_2 is the end date. Type is one of
two possible values, 0 (interval) or 1 (in
calendar months). If Date_2 is an earlier date
than Date_1, the result is a negative number.
NETWORKDAYS(start
_date; end_date; holidays)
Returns the number of workdays between
start_date and end_date. Holidays can be
deducted. Start_date is the date from which
the calculation is carried out. End_date is the
date up to which the calculation is carried out.
If the start or end date is a workday, the day is
included in the calculation. Holidays
(optional) is a list of holidays. Enter a cell
range in which the holidays are listed
individually.
460 OpenOffice.org 3.x Calc Guide