Excel TIME and DATE functions Syntax List

Last modified date

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
1DATEDATE(year,month,
day)
2DATAVALUEDATEVALUE(date_text)
3DAYDAY(serial_number)
4DAYSDAYS(end_date,
start_date)
5DAYS360DAYS360(start_date,
end_date,[method])
6EDATEEDATE(start_date,
months)
7EOMONTHEOMONTH(start_date,
months)
8HOURHOUR(serial_number)
9ISOWEEKNUMISOWEEKNUM(date)
10MINUTEMINUTE(serial_number)
11NETWORKDAYS NETWORKDAYS
(start_date,
end_date,[holidays])
12NETWORKDAYS.INTLNETWORKDAYS.INTL
(start_date,
end_date,
[weekend],
[holidays])
13NOWNOW()
14SECONDSECOND
(serial_number)
15TIMETIME(hour,
minute,
second)
16 TIMEVALUETIMEVALUE(time_text)
17TODAYTODAY()
18WEEKDAYWEEKDAY
(serial_number,
[return_type])
19 WEEKNUMWEEKNUM
(serial_number,
[return_type])
20WORKDAYWORKDAY
(start_date,days,
[holidays])
21 WORKDAY.INTLWORKDAY.INTL
(start_date,
days,
[weekend],
[holidays])
22YEARYEAR(serial_number)
23YEARFRACYEARFRAC(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

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment