Date/Time

year: year between 1582 and 9956, defaults to the year of the next Ascension Thursday

Two digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.

EASTERSUNDAY.

year: year between 1582 and 9956, defaults to the year of the next Ash Wednesday

Two digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.

EASTERSUNDAY.

year: year of date

month: month of year

day: day of month

The DATE function creates date serial values. 1-Jan-1900 is serial value 1, 2-Jan-1900 is serial value 2, and so on. For compatibility reasons, a serial value is reserved for the non-existing date 29-Feb-1900.

If month or day is less than 1 or too big, then the year and/or month will be adjusted. For spreadsheets created with the Mac version of Excel, serial 1 is 1-Jan-1904.

This function is Excel compatible.

TODAY, YEAR, MONTH, DAY.

date: Gregorian date, defaults to today

HDATE, DATE2HDATE_HEB.

date: Gregorian date, defaults to today

DATE2HDATE, HDATE_HEB.

date: Gregorian date, defaults to today

HDATE_JULIAN.

d: date

The DATE2UNIX function translates a date into a Unix timestamp. A Unix timestamp is the number of seconds since midnight (0:00) of January 1st, 1970 GMT.

UNIX2DATE, DATE.

start_date: starting date serial value

end_date: ending date serial value

interval: counting unit

DATEDIF returns the distance from start_date to end_date according to the unit specified by interval.

If interval is "y", "m", or "d" then the distance is measured in complete years, months, or days respectively. If interval is "ym" or "yd" then the distance is measured in complete months or days, respectively, but excluding any difference in years. If interval is "md" then the distance is measured in complete days but excluding any difference in months.

This function is Excel compatible.

DAYS360.

serial: date and time serial value

DATEVALUE returns the date serial value part of a date and time serial value.

This function is Excel compatible.

TIMEVALUE, DATE.

date: date serial value

The DAY function returns the day-of-month part of date.

This function is Excel compatible.

DATE, YEAR, MONTH.

end_date: ending date serial value

start_date: starting date serial value

DAYS returns the positive or negative number of days from start_date to end_date.

This function is OpenFormula compatible.

DATEDIF.

start_date: starting date serial value

end_date: ending date serial value

method: counting method

DAYS360 returns the number of days from start_date to end_date.

If method is 0, the default, the MS Excel (tm) US method will be used. This is a somewhat complicated industry standard method where the last day of February is considered to be the 30th day of the month, but only for start_date. If method is 1, the European method will be used. In this case, if the day of the month is 31 it will be considered as 30 If method is 2, a saner version of the US method is used in which both dates get the same February treatment.

This function is Excel compatible.

DATEDIF.

year: year between 1582 and 9956, defaults to the year of the next Easter Sunday

Two digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.

The 1-argument version of EASTERSUNDAY is compatible with OpenOffice for years after 1904. This function is not specified in ODF/OpenFormula.

ASHWEDNESDAY.

date: date serial value

months: signed number of months

EDATE returns date moved forward or backward the number of months specified by months.

This function is Excel compatible.

DATE.

date: date serial value

months: signed number of months

EOMONTH returns the date serial value of the end of the month specified by date adjusted forward or backward the number of months specified by months.

This function is Excel compatible.

EDATE.

year: year between 1582 and 9956, defaults to the year of the next Good Friday

Two digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.

EASTERSUNDAY.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE_HEB, DATE.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE_JULIAN.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE, DATE.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE_JULIAN.

year: Gregorian year of date, defaults to the current year

month: Gregorian month of year, defaults to the current month

day: Gregorian day of month, defaults to the current day

HDATE_JULIAN.

time: time of day as fractional day

The HOUR function computes the hour part of the fractional day given by time.

This function is Excel compatible.

TIME, MINUTE, SECOND.

date: date serial value

ISOWEEKNUM calculates the week number according to the ISO 8601 standard. Weeks start on Mondays and week 1 contains the first Thursday of the year.

January 1 of a year is sometimes in week 52 or 53 of the previous year. Similarly, December 31 is sometimes in week 1 of the following year.

ISOYEAR, WEEKNUM.

date: date serial value

ISOYEAR calculates the year to go with week number according to the ISO 8601 standard.

January 1 of a year is sometimes in week 52 or 53 of the previous year. Similarly, December 31 is sometimes in week 1 of the following year.

ISOWEEKNUM, YEAR.

time: time of day as fractional day

The MINUTE function computes the minute part of the fractional day given by time.

This function is Excel compatible.

TIME, HOUR, SECOND.

date: date serial value

The MONTH function returns the month part of date.

This function is Excel compatible.

DATE, YEAR, DAY.

start_date: starting date serial value

end_date: ending date serial value

holidays: array of holidays

weekend: array of 0s and 1s, indicating whether a weekday (S, M, T, W, T, F, S) is on the weekend, defaults to {1,0,0,0,0,0,1}

NETWORKDAYS calculates the number of days from start_date to end_date skipping weekends and holidays in the process.

If an entry of weekend is non-zero, the corresponding weekday is not a work day.

This function is Excel compatible if the last argument is omitted.

This function is OpenFormula compatible.

WORKDAY.

The NOW function returns the date and time serial value of the moment it is computed. Recomputing later will produce a different value.

This function is Excel compatible.

DATE.

hour: hour

minute: minute

second: second

The ODF.TIME function computes the time given by hour, minute, and second as a fraction of a day.

While the return value is automatically formatted to look like a time between 0:00 and 24:00, the underlying serial time value can be any number.

This function is OpenFormula compatible.

TIME, HOUR, MINUTE, SECOND.

year: year between 1582 and 9956, defaults to the year of the next Pentecost Sunday

Two digit years are adjusted as elsewhere in Gnumeric. Dates before 1904 may also be prohibited.

EASTERSUNDAY.

time: time of day as fractional day

The SECOND function computes the seconds part of the fractional day given by time.

This function is Excel compatible.

TIME, HOUR, MINUTE.

hour: hour of the day

minute: minute within the hour

second: second within the minute

The TIME function computes the fractional day after midnight at the time given by hour, minute, and second.

While the return value is automatically formatted to look like a time between 0:00 and 24:00, the underlying serial time value is a number between 0 and 1. If any of hour, minute, and second is negative, #NUM! is returned

This function is Excel compatible.

ODF.TIME, HOUR, MINUTE, SECOND.

serial: date and time serial value

TIMEVALUE returns the time-of-day part of a date and time serial value.

This function is Excel compatible.

DATEVALUE, TIME.

The TODAY function returns the date serial value of the day it is computed. Recomputing on a later date will produce a different value.

This function is Excel compatible.

DATE.

t: Unix time stamp

The UNIX2DATE function translates Unix timestamps into the corresponding date. A Unix timestamp is the number of seconds since midnight (0:00) of January 1st, 1970 GMT.

DATE2UNIX, DATE.

date: date serial value

method: numbering system, defaults to 1

The WEEKDAY function returns the day-of-week of date. The value of method determines how days are numbered; it defaults to 1.

If method is 1, then Sunday is 1, Monday is 2, etc. If method is 2, then Monday is 1, Tuesday is 2, etc. If method is 3, then Monday is 0, Tuesday is 1, etc. If method is 11, then Monday is 1, Tuesday is 2, etc. If method is 12, then Tuesday is 1, Wednesday is 2, etc. If method is 13, then Wednesday is 1, Thursday is 2, etc. If method is 14, then Thursday is 1, Friday is 2, etc. If method is 15, then Friday is 1, Saturday is 2, etc. If method is 16, then Saturday is 1, Sunday is 2, etc. If method is 17, then Sunday is 1, Monday is 2, etc.

This function is Excel compatible.

DATE, ISOWEEKNUM.

date: date serial value

method: numbering system, defaults to 1

WEEKNUM calculates the week number according to method which defaults to 1.

If method is 1, then weeks start on Sundays and January 1 is in week 1. If method is 2, then weeks start on Mondays and January 1 is in week 1. If method is 150, then the ISO 8601 numbering is used.

ISOWEEKNUM.

date: date serial value

days: number of days to add

holidays: array of holidays

weekend: array of 0s and 1s, indicating whether a weekday (S, M, T, W, T, F, S) is on the weekend, defaults to {1,0,0,0,0,0,1}

WORKDAY adjusts date by days skipping over weekends and holidays in the process.

days may be negative. If an entry of weekend is non-zero, the corresponding weekday is not a work day.

This function is Excel compatible if the last argument is omitted.

This function is OpenFormula compatible.

NETWORKDAYS.

date: date serial value

The YEAR function returns the year part of date.

This function is Excel compatible.

DATE, MONTH, DAY.

start_date: starting date serial value

end_date: ending date serial value

basis: calendar basis

YEARFRAC calculates the number of days from start_date to end_date according to the calendar specified by basis, which defaults to 0, and expresses the result as a fractional number of years.

If basis is 0, then the US 30/360 method is used. If basis is 1, then actual number of days is used. If basis is 2, then actual number of days is used within a month, but years are considered only 360 days. If basis is 3, then actual number of days is used within a month, but years are always considered 365 days. If basis is 4, then the European 30/360 method is used.

DATE.