List of Excel Date and Time Functions with Syntax and Arguments

This reference table lists all officially documented Date and Time Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.

#Excel FunctionDescriptionSyntax with ArgumentsSyntax onlyArguments only
1DATECombines three separate values to form a date=DATE (yearyear [required]: The value of the year argument can include one to four digits. , monthmonth [required]: A positive or negative integer representing the month of the year from 1 to 12., dayday [required]: A positive or negative integer representing the day of the month from 1 to 31.)=DATE (year, month, day)
  • year (required): The value of the year argument can include one to four digits.
  • month (required): A positive or negative integer representing the month of the year from 1 to 12.
  • day (required): A positive or negative integer representing the day of the month from 1 to 31.
2DATEDIFCalculates the number of days, months, or years between two dates=DATEDIF(start_datestart_date [required]: A date that represents the first, or starting date of a given period., end_dateend_date [required]: A date that represents the last, or ending, date of the period., unitunit [required]: The type of information that you want returned, where:)=DATEDIF(start_date, end_date, unit)
  • start_date (required): A date that represents the first, or starting date of a given period.
  • end_date (required): A date that represents the last, or ending, date of the period.
  • unit (required): The type of information that you want returned, where:
3DATEVALUEConverts a date that is stored as text to a serial number that Excel recognizes as a date. =DATEVALUE(date_textdate_text [required]: Text that represents a date in an Excel date format, or a reference to a cell that contains text that represents a date in an Excel date format.)=DATEVALUE(date_text)
  • date_text (required): Text that represents a date in an Excel date format, or a reference to a cell that contains text that represents a date in an Excel date format.
4DAYReturns the day of a date, represented by a serial number=DAY(serial_numberserial_number [required]: The date of the day you are trying to find.)=DAY(serial_number)
  • serial_number (required): The date of the day you are trying to find.
5DAYSReturns the number of days between two dates=DAYS(end_dateend_date [required]: From which date you want to know the number of days., start_datestart_date [required]: Until which date you want to know the number of days.)=DAYS(end_date, start_date)
  • end_date (required): From which date you want to know the number of days.
  • start_date (required): Until which date you want to know the number of days.
6DAYS360Returns the number of days between two dates based on a 360-day year=DAYS360(start_datestart_date [required]: From which date you want to know the number of days.,end_dateend_date [required]: Until which date you want to know the number of days.,[methodmethod [optional]: A logical value that specifies whether to use the U.S. or European method in the calculation.])=DAYS360(start_date,end_date,[method])
  • start_date (required): From which date you want to know the number of days.
  • end_date (required): Until which date you want to know the number of days.
  • method (optional): A logical value that specifies whether to use the U.S. or European method in the calculation.
7EDATEReturns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date)=EDATE(start_datestart_date [required]: A date that represents the start date., monthsmonths [required]: The number of months before or after start_date.)=EDATE(start_date, months)
  • start_date (required): A date that represents the start date.
  • months (required): The number of months before or after start_date.
8EOMONTHReturns the serial number for the last day of the month that is the indicated number of months before or after start_date=EOMONTH(start_datestart_date [required]: A date that represents the starting date., monthsmonths [required]: The number of months before or after start_date.)=EOMONTH(start_date, months)
  • start_date (required): A date that represents the starting date.
  • months (required): The number of months before or after start_date.
9HOURReturns the hour of a time value=HOUR(serial_numberserial_number [required]: The time that contains the hour you want to find.)=HOUR(serial_number)
  • serial_number (required): The time that contains the hour you want to find.
10ISOWEEKNUMReturns number of the ISO week number of the year for a given date=ISOWEEKNUM(datedate [required]: Date is the date-time code used by Excel for date and time calculation.)=ISOWEEKNUM(date)
  • date (required): Date is the date-time code used by Excel for date and time calculation.
11MINUTEReturns the minutes of a time value=MINUTE(serial_numberserial_number [required]: The time that contains the minute you want to find.)=MINUTE(serial_number)
  • serial_number (required): The time that contains the minute you want to find.
12MONTHReturns the month of a date represented by a serial number=MONTH(serial_numberserial_number [required]: The date of the month you are trying to find.)=MONTH(serial_number)
  • serial_number (required): The date of the month you are trying to find.
13NETWORKDAYSReturns the number of whole working days between start_date and end_date=NETWORKDAYS(start_datestart_date [required]: A date that represents the start date., end_dateend_date [required]: A date that represents the end date., [holidaysholidays [optional]: An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays.])=NETWORKDAYS(start_date, end_date, [holidays])
  • start_date (required): A date that represents the start date.
  • end_date (required): A date that represents the end date.
  • holidays (optional): An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays.
14NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
    15NOWReturns the serial number of the current date and time. =NOW()=NOW()
      16SECONDReturns the seconds of a time value=SECOND(serial_numberserial_number [required]: The time that contains the seconds you want to find.)=SECOND(serial_number)
      • serial_number (required): The time that contains the seconds you want to find.
      17TIMEReturns the decimal number for a particular time=TIME(hourhour [required]: A number from 0 (zero) to 32767 representing the hour., minuteminute [required]: A number from 0 to 32767 representing the minute., secondsecond [required]: A number from 0 to 32767 representing the second.)=TIME(hour, minute, second)
      • hour (required): A number from 0 (zero) to 32767 representing the hour.
      • minute (required): A number from 0 to 32767 representing the minute.
      • second (required): A number from 0 to 32767 representing the second.
      18TIMEVALUEReturns the decimal number of the time represented by a text string=TIMEVALUE(time_texttime_text [required]: A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.)=TIMEVALUE(time_text)
      • time_text (required): A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.
      19TODAYReturns the serial number of the current date=TODAY()=TODAY()
        20WEEKDAYReturns the day of the week corresponding to a date=WEEKDAY(serial_numberserial_number [required]: A sequential number that represents the date of the day you are trying to find., [return_typereturn_type [optional]: A number that determines the type of return value.])=WEEKDAY(serial_number, [return_type])
        • serial_number (required): A sequential number that represents the date of the day you are trying to find.
        • return_type (optional): A number that determines the type of return value.
        21WEEKNUMReturns the week number of a specific date=WEEKNUM(serial_numberserial_number [required]: A date within the week., [return_typereturn_type [optional]: A number that determines on which day the week begins.])=WEEKNUM(serial_number, [return_type])
        • serial_number (required): A date within the week.
        • return_type (optional): A number that determines on which day the week begins.
        22WORKDAYReturns a number that represents a date that is the indicated number of working days before or after a date (the starting date)=WORKDAY(start_datestart_date [required]: A date that represents the start date., daysdays [required]: The number of nonweekend and nonholiday days before or after start_date., [holidaysholidays [optional]: An optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays.])=WORKDAY(start_date, days, [holidays])
        • start_date (required): A date that represents the start date.
        • days (required): The number of nonweekend and nonholiday days before or after start_date.
        • holidays (optional): An optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays.
        23WORKDAY.INTLReturns the serial number of the date before or after a specified number of workdays with custom weekend parameters=WORKDAY.INTL(start_datestart_date [required]: The start date, truncated to integer., daysdays [required]: The number of workdays before or after the start_date., [weekendweekend [optional]: Indicates the days of the week that are weekend days and are not considered working days.], [holidaysholidays [optional]: An optional set of one or more dates that are to be excluded from the working day calendar.])=WORKDAY.INTL(start_date, days, [weekend], [holidays])
        • start_date (required): The start date, truncated to integer.
        • days (required): The number of workdays before or after the start_date.
        • weekend (optional): Indicates the days of the week that are weekend days and are not considered working days.
        • holidays (optional): An optional set of one or more dates that are to be excluded from the working day calendar.
        24YEARReturns the year corresponding to a date=YEAR(serial_numberserial_number [required]: The date of the year you want to find.)=YEAR(serial_number)
        • serial_number (required): The date of the year you want to find.
        25YEARFRACReturns the year corresponding to a date=YEARFRAC(start_datestart_date [required]: A date that represents the start date., end_dateend_date [required]: A date that represents the end date., [basisbasis [optional]: The type of day count basis to use.])=YEARFRAC(start_date, end_date, [basis])
        • start_date (required): A date that represents the start date.
        • end_date (required): A date that represents the end date.
        • basis (optional): The type of day count basis to use.

        Created by admin on 2/9/2021

         

        0 Comments for '(Excel) - List of Excel Date and Time Functions with Syntax and Arguments'   

         
        Email me replies   

        Please kindly review and accept Terms of Use and Cookie & Policy Policy