OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung PDF herunterladen (Seite 403)

Syntax Description

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).

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.

Appendix B Description of Functions 403

1 2 ... 398 399 400 401 402 403 404 405 406 407 408 ... 433 434

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung Seite 403

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software OpenOffice.org OpenOffice - 3.3