DATE(year; month; day)

Converts a date written as year, month, day to an internal serial number and displays it in the cellâ€™s formatting. Year is an integer between 1583 and 9956 or 0 and 99. Month is an integer between 1 and 12. Day is an integer between 1 and 31.

DATEVALUE("Text")

Returns the internal date number for text in quotes. Text is a valid date expression and must be entered with quotation marks.

DAY(number)

Returns the day, as an integer, of the given date value. A negative date/time value can be entered. Number is a time value.

DAYS(date_2; date_1)

Calculates the difference, in days, between two date values. Date_1 is the start date. Date_2 is the end date. If Date_2 is an earlier date than Date_1, the result is a negative number.

DAYS360(date_1; date_2; type)

Returns the difference between two dates based on the 360 day year used in interest calculations. If Date_2 is earlier than Date_1, the function will return a negative number. Type (optional) determines the type of difference calculation: the US method (0) or the European method (â‰ 0).

*DAYSINMONTH(date)

Calculates the number of days in the month of the given date.

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

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

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