The Excel HOUR function returns the hour of the day, a number from 0 (12:00 AM) to 23 (11:00 PM). The HOUR function is an Excel date and time function.

The Excel YEAR function returns the year, a number between 1900 and 9999. The YEAR function is an Excel date and time function.

The Excel MONTH function returns the month of the year, a number between 1 and 12. The MONTH function is an Excel date and time function.

The Excel DAY function returns the day of the month, a number between 1 and 31.The DAY function is an Excel date and time function.

The Excel DATE function returns the number that represents a date in Excel. If the cell number format is set to a date type then the number will be shown as a date. The DATE function is an Excel date and time function.