Category: Time & Date Functions

Excel Time and Date functions Syntax List
Excel Functions, Time & Date Functions

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])Continue reading