Date




Date Function - Google Spreadsheet Functions:




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:


Date Functions - Spreadsheet Examples