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
Returns the number of years, months, or days between two dates.
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 calculates the difference between two date values. The result is an integer and returns the number of days between the two days.
HOUR returns the hour for a given time value. The hour is returned as an integer 0 - 23.
MINUTE calculates the minute for an internal time value. The minute is returned as a number 0 - 59.
MONTH returns the month for the given date value. The month is returned as a number 1 - 12.
NETWORKDAYS returns the number of workdays between the start date and the end date. Optionally, a list of holidays can be deducted.
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 returns the second for the given time value. The second is returned as an integer 0 - 59.
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 returns the current computer system date. The value is updated when you reopen the document or modify the values of the document.
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 calculates the week number of the year for the internal date value.
YEAR returns the year as a number according to the internal calculation rules.