Date & Time functions in Excel

Hello All. In this section, let’s look at all the Date&Time functions in excel. Here is the table with the usage & syntax for all the functions under this category.

 Function Usage  Syntax 
 DATE  Create a date with year, month & date  =Date(year, month, date)
 DATEVALUE  Convert a date in text format to a valid date format  =Datevalue(date_text)
 DAY   Returns the day (1 to 31) from the date value      =day(number)
 DAYS  Returns days between dates  =days(end_date, start_date)
 DAYS360  Returns days between 2 days in a 360-day year (12 x 30 days month)      =days360(start_date,end_date,[method])
 EDATE  Returns the date that is the indicated number of months before or after the start date     =edate(start_date,months) 
 EOMONTH  Returns the last day of the month before or after the specified number of months =eomonth(start_date,month) 
 HOUR  Returns the hour as a number between 0 and 23 from a time value    =hour(serial number) 
 ISOWEEKNUM  Returns ISO week number for a given date    =isoweeknum(date) 
 MINUTE  Returns minute as a number between 0 and 59 from a time value =minute(serial number) 
 MONTH  Returns month as a number between 1 and 12 from a date  =month(date)
 NETWORKDAYS  Return the number of working days between two dates  =networkdays(start_date, end_date,[holidays])
 NETWORKDAYS.INTL  Return the number of working days between two days with custom weekend parameters  =networkdays.intl(start_date, end_date,[weekend],[holidays])
 NOW  Return the current date and time =now() 
 SECOND  Returns second as a number between 1 and 59 from a time value =second(serial number) 
 TIME  Create time value with hours, minutes and seconds     =time(hour, minute, second) 
 TIMEVALUE  Convert the time in text format to proper time format     =timevalue(time_text) 
 TODAY  Returns the current date =today() 
 WEEKDAY  Return the day of the week as number =weekday(serial number, [return type]) 
 WEEKNUM     Return the week number between 1 and 52 for a given date  =weeknum(serial number, [return type]) 
 WORKDAY  Returns the date before and after the specified number of working days =workday(start_date,days,..[holidays]) 
 WORKDAY.INTL  Returns the date before and after the specified number of working days with custom weekend parameters =workday.intl(start_Date,days,[weekend],[holidays]) 
 YEAR  Return the year from a date value (value between 1900 – 9999)  =year(date)
 YEARFRAC  Return the fraction of a year between two dates =yearfrac(start_date, end_date,[basis]) 
I hope you like this one pager on all the Date & Time functions. Please let us know you valuable feedback that would help to improve the content. Thanks for reading.

Leave a Reply

%d bloggers like this: