Date and time functions allow you to alter the display and use of cells with date and/or time values.
|
Returns a United States style date for the given day, month, and year.
| |
|
Converts any date value into a specific text format.
| |
|
Returns just the day (1..31) of the month for the specified date.
| |
|
Returns the name of the given day of the week.
| |
|
Returns the day (1..366) of the year for given a date.
| |
|
Returns the hour (0-23) of the day for a given time.
| |
|
Returns the local time. If no time is specified, the current time is used. If no timezone offset is specified, the offset of current zone is used.
| |
|
Returns the minute (0-59) for a given time.
| |
|
Returns the month (1-12) for the given date.
| |
|
Returns the month (1-12) for the given date.
| |
|
Returns the immediate GMT time. See also LOCALTIME
| |
|
Returns the seconds (0-59) for a given time.
| |
|
Returns a text string for a given time.
| |
|
Converts any time value into a specific text format.
| |
|
Returns the difference in hours from UTC time.
| |
|
Returns a day of the week value given a specific date. Returns a numeric value (0-6) where Sunday is 0 and Saturday is 6.
| |
|
Returns a week of a year value given a specific date. Returns a numeric value (0-53) where the first week of a year is 1, the second is 2, and so forth.
| |
|
Returns the year for a given date. |