Excel has quite a few functions that work with dates. These functions are accessible by choosing Formula >> Function Library >> Date & Time
5.1) Day: The Day function displays the day portion of a date
Syntax = DAY(serial_number)
Example
5.2) Date: This function returns a serial date value.
Syntax = DATE(year, month, day)
Example
Syntax = MONTH(serial_number)
Example
5.4) Year: The Year function displays the year portion of a date.
Syntax = YEAR (serial_number)
Example
Syntax = DATEVALUE(date_text)
Example
5.6) Today: This function display current date.
Syntax = TODAY()
Example
5.7) Weekday: This function has two arguments: serial_number and return_type. The serial_number argument is simply a number that represents a date. The return_type argument is optional, and assumed to be 1 if omitted
Syntax = WEEKDAY(serial_number, [return_type])
Example
5.8) Timevalue: Returns the decimal number of the time represented by a text string
Syntax = TIMEVALUE(time_text)
Example
5.9) Time: Returns the decimal number for a particular time.
Syntax = TIME(hour, minute, second)
Example
5.10) Hour: Return the hours portion of a time value
Syntax = HOUR(serial_number)
Example
5.11) Second: Return the seconds portion of a time value.
Syntax = SECOND(serial_number)
Example
5.12) Minute: Return the minute portion of a time value
Syntax = MINUTE(serial_number)
Example