Date and Time Functions

📄️ Date

Calculates the sequential decimal number that represents a particular date, counting from January 1, 1900.

Returns a date object from the specifed year, month, day, hour, minute, second.

Calculates the day of the month (from 1 to 31) of a given decimal value date.

Calculates the hour of a given time value.

Calculates the minute of a given time value.

Calculates the month of a given time value.

Calculates the second of a given time value.

Converts a time (expressed as hh:mm:ss) to a decimal number counting from December 1, 1900.

Calculates the day of the week (Sunday, Monday, etc.) for a specified date.

Calculates the year (as an integer from 1900 to 9999) of a date given as a serial number.