Date & Time
Date & Time functions (reference)
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
Last updated