NOW =NOW()

TODAY =TODAY()

DATE =DATE(year, month, day)

TIME =TIME(hour, minute, second)

SECOND =SECOND(number)

MINUTE =MINUTE(number)

HOUR =HOUR(number)

DAY =DAY(number)

MONTH =MONTH(number)

YEAR =YEAR(number)

DATEVALUE =DATEVALUE(text)

EDATE =EDATE(start_date, months)

EOMONTH =EOMONTH(start_date, months)

WEEKDAY =WEEKDAY(number, type)

DAYS360 =DAYS360(date_1, date_2, type)

WORKDAY =WORKDAY(start_date, days, holidays)

YEARFRAC =YEARFRAC(start_date, end_date, basis)

NETWORKDAYS =NETWORKDAYS(start _date, end_date, holidays)

Date Function - Spreadsheet Examples: