Date & Time

Date & Time functions (reference)

Function	Description
DATE	Returns a date, from a user-supplied year, month and day. syntax: =DATE(year,month,dayOfMonth) example: DATE(2017,1,21) result: Returns Java Date Instance
TIME	Returns a time, from a user-supplied hour, minute and second.
DATEVALUE	Converts a text string showing a date, to java date syntax: =DATEVALUE(time_in_string, format(optional)) example: =DATEVALUE("12/12/2017") or =DATEVALUE("12/12/2017","dd/mm/yyyy") result: Java date instance
TIMEVALUE	Converts a text string showing a time, to a decimal that represents the time in Excel. example: =TIMEVALUE("10:10 AM") result: java instance with time and default date
NOW	Returns the current date & time. syntax: =NOW() result: returns Java Date Instance with time
TODAY	Returns today's date. syntax: =TODAY() result: returns Java Date Instance without time