NOW()
Description: Returns the current date and time.
Example: =Now()
TODAY() & Now()
Description:today(): Returns the current date. now(): Returns the current date with time.
Example: =TODAY()
Example: =NOW()
DATE(year, month, day)
Description: Returns the date specified by the year, month, and day arguments.
Example: =DATE(2023, 9, 15)
YEAR(serial_number)
Description: Returns the year of a specified date.
Example: =YEAR(TODAY())
MONTH(serial_number)
Description: Returns the month of a specified date.
Example: =MONTH(TODAY())
DAY(serial_number)
Description: Returns the day of the month of a specified date.
Example: =DAY(TODAY())
HOUR(serial_number)
Description:Returns the hour of a specified time.
Example: =HOUR(NOW())
MINUTE(serial_number)
Description: Returns the minutes of a specified time.
Example: =MINUTE(NOW())
SECOND(serial_number)
Description: Returns the seconds of a specified time.
Example: =SECOND(NOW())
TIME(hour, minute, second)
Description:Returns the time specified by the hour, minute, and second arguments.
Example: =TIME(13, 30, 0)