# Date & Time | 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

|