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 Function | Description | Syntax with Arguments | Syntax only | Arguments only |
|---|---|---|---|---|---|
| 1 | DATE | Combines 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) |
|
| 2 | DATEDIF | Calculates 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) |
|
| 3 | DATEVALUE | Converts 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) |
|
| 4 | DAY | Returns 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) |
|
| 5 | DAYS | Returns 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) |
|
| 6 | DAYS360 | Returns 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]) |
|
| 7 | EDATE | Returns 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) |
|
| 8 | EOMONTH | Returns 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) |
|
| 9 | HOUR | Returns the hour of a time value | =HOUR(serial_numberserial_number [required]: The time that contains the hour you want to find.) | =HOUR(serial_number) |
|
| 10 | ISOWEEKNUM | Returns 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) |
|
| 11 | MINUTE | Returns the minutes of a time value | =MINUTE(serial_numberserial_number [required]: The time that contains the minute you want to find.) | =MINUTE(serial_number) |
|
| 12 | MONTH | Returns 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) |
|
| 13 | NETWORKDAYS | Returns 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]) |
|
| 14 | NETWORKDAYS.INTL | Returns 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]) | |
| 15 | NOW | Returns the serial number of the current date and time. | =NOW() | =NOW() | |
| 16 | SECOND | Returns the seconds of a time value | =SECOND(serial_numberserial_number [required]: The time that contains the seconds you want to find.) | =SECOND(serial_number) |
|
| 17 | TIME | Returns 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) |
|
| 18 | TIMEVALUE | Returns 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) |
|
| 19 | TODAY | Returns the serial number of the current date | =TODAY() | =TODAY() | |
| 20 | WEEKDAY | Returns 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]) |
|
| 21 | WEEKNUM | Returns 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]) |
|
| 22 | WORKDAY | Returns 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]) |
|
| 23 | WORKDAY.INTL | Returns 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]) |
|
| 24 | YEAR | Returns the year corresponding to a date | =YEAR(serial_numberserial_number [required]: The date of the year you want to find.) | =YEAR(serial_number) |
|
| 25 | YEARFRAC | Returns 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]) |
|
Advertising for Consideration:
Ads for Consideration:
Please kindly review and accept Terms of Use and Cookie & Policy Policy