YEAR Function

Year Function
This function returns the month from a given date/Number.
Syntax: YEAR(serial_number)
Example: =YEAR("2 July 2011") Result: 2011



Function can be used with NOW(), TODAY() Functions

TIMEVALUE Function

TIMEVALUE Function

This function converts a text string showing a time, to a decimal that represents the time in Excel.

Syntax: TIMEVALUE(time_text)

Formula: =TIMEVALUE("4:50 AM")
Result:  0.21388889





Formula: =TIMEVALUE("6:00 AM")
Result:  0.25

DATEVALUE Function

DATEVALUE Function


This function Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.

Syntax: DATEVALUE(date_text)
Formula: =DATEVALUE("6/6/2012")
Result: 41066

SECOND Function

SECOND Function

This function is used to get Second from given time.

Syntax: SECOND(serial_number)

Example: =SECOND("5:27:35")
Result: 35




 

Example: =SECOND(NOW())
Result: 26