Calc Guide

Syntax Description
WEEKSINYEAR(date) Calculates the number of weeks in a year until
a certain date. A week that spans two years is
added to the year in which most days of that
week occur.
WORKDAY(start_date;
days; holidays)
Returns a date number that can be formatted
as a date. You then see the date of a day that is
a certain number of Workdays away from the
start_date. Holidays (optional) is a list of
holidays. Enter a cell range in which the
holidays are listed individually.
YEAR(number) Returns the year as a number according to the
internal calculation rules. Number shows the
internal date value for which the year is to be
returned.
YEARFRAC(start_date;
end_date; basis)
Returns a number between 0 and 1,
representing the fraction of a year between
start_date and end_date. Start_date and
end_date are two date values. Basis is chosen
from a list of options and indicates how the
year is to be calculated.
YEARS(tart_date;
end_date; type)
Calculates the difference in years between two
dates: the start_date and the end_date. Type
calculates the type of difference.
Logical functions
Use the logical functions to test values and produce results based on
the result of the test. These functions are conditional and provide the
ability to write longer formulas based on input or output.
Table 39: Logical functions
Syntax Description
AND(logical_value_1;
logical_value_2;
...logical_value_30)
Returns TRUE if all arguments are TRUE. If any
element is FALSE, this function returns the FALSE
value. Logical_value_1; logical_value_2;
...logical_value_30 are conditions to be checked.
All conditions can be either TRUE or FALSE. If a
range is entered as a parameter, the function uses
the value from the range that is in the current
column or row. The result is TRUE if the logical
value in all cells within the cell range is TRUE
462 OpenOffice.org 3.x Calc Guide