Excel TIME and DATE functions Syntax List

Below the list of Excel TIME and DATE Functions, at bottom of the table links are provided to download this data in PDF and Excel Formats.
S.No | Function | Syntax |
1 | DATE | DATE(year day) |
2 | DATAVALUE | DATEVALUE(date_text) |
3 | DAY | DAY(serial_number) |
4 | DAYS | DAYS(end_date, start_date) |
5 | DAYS360 | DAYS360(start_date, end_date,[method]) |
6 | EDATE | EDATE(start_date, months) |
7 | EOMONTH | EOMONTH(start_date, months) |
8 | HOUR | HOUR(serial_number) |
9 | ISOWEEKNUM | ISOWEEKNUM(date) |
10 | MINUTE | MINUTE(serial_number) |
11 | NETWORKDAYS | NETWORKDAYS (start_date, end_date,[holidays]) |
12 | NETWORKDAYS.INTL | NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]) |
13 | NOW | NOW() |
14 | SECOND | SECOND (serial_number) |
15 | TIME | TIME(hour, minute, second) |
16 | TIMEVALUE | TIMEVALUE(time_text) |
17 | TODAY | TODAY() |
18 | WEEKDAY | WEEKDAY (serial_number, [return_type]) |
19 | WEEKNUM | WEEKNUM (serial_number, [return_type]) |
20 | WORKDAY | WORKDAY (start_date,days, [holidays]) |
21 | WORKDAY.INTL | WORKDAY.INTL (start_date, days, [weekend], [holidays]) |
22 | YEAR | YEAR(serial_number) |
23 | YEARFRAC | YEARFRAC(start_date, end_date,[basis]) |
Click here to download the Excel workbook format of Excel TIME and DATE functions Syntax List
Click here to download the PDF format of Excel TIME and DATE functions Syntax List