These spreadsheet functions are used for inserting and editing dates and times.

- DATE function

DATE converts a date written as year, month, day to an internal serial number and displays it in the formatting of the cell. The default format of a cell containing the DATE function is the date format. However, you can format the cells with the 0 number format, which displays the internal serial number of the date as a number. If the values for month and day are higher, they are carried over to the next digit. If you enter`=DATE(00,12,31)`the result is`12/31/00`. However, if you enter`=DATE(00,13,31)`the result is`1/31/01`. - DATEDIF function

Returns the number of years, months, or days between two dates. - DAY function

DAY returns the day of a given date value. The day is returned as a value 1 - 31. You can also enter a negative date/time value. - DAYS function

DAYS calculates the difference between two date values. The result is an integer and returns the number of days between the two days. - HOUR function

HOUR returns the hour for a given time value. The hour is returned as an integer 0 - 23. - MINUTE function

MINUTE calculates the minute for an internal time value. The minute is returned as a number 0 - 59. - MONTH function

MONTH returns the month for the given date value. The month is returned as a number 1 - 12. - NETWORKDAYS function

NETWORKDAYS returns the number of workdays between the start date and the end date. Optionally, a list of holidays can be deducted. - NOW function

NOW returns the computer system date and time. The value is updated when you recalculate the document or each time that a cell value is modified. - SECOND function

SECOND returns the second for the given time value. The second is returned as an integer 0 - 59. - TIME function

TIME 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. - TODAY function

TODAY returns the current computer system date. The value is updated when you reopen the document or modify the values of the document. - WEEKDAY function

WEEKDAY returns the day of the week for the given date value. The day is returned as an integer between 1 and 7. The day of the week on which numbering begins depends on the type. - WEEKNUM function

WEEKNUM calculates the week number of the year for the internal date value. - YEAR function

YEAR returns the year as a number according to the internal calculation rules.