YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or …
serial_number
WEEKNUM Function
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week …
WEEKDAY Function
The WEEKDAY Function in Excel returns an integer that represents a day of the week.
MONTH Function
The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number) Arguments serial_number – (required) The date that contains …
MINUTE Function
The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number) Arguments serial_number – (required) The time that contains …
HOUR Function in Excel
What time is it? The HOUR Function can grab, you guessed it, the HOUR!