Excel functions

Every Excel function (476), organized by category. Arguments in [brackets] are optional.

Formula Explainer · Paste any formula and see it broken down step by step. Free.

Date & Time (25)

=DATE(year, month, day)

Returns the serial number of a particular date.

=DATEDIF(start_date, end_date, unit)

Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.

=DATEVALUE(date_text)

Converts a date in the form of text to a serial number.

=DAY(serial_number)

Converts a serial number to a day of the month.

=DAYS(end_date, start_date)

Returns the number of days between two dates.

=DAYS360(start_date, end_date, [method])

Calculates the number of days between two dates based on a 360-day year.

=EDATE(start_date, months)

Returns the serial number of the date that is the indicated number of months before or after the start date.

=EOMONTH(start_date, months)

Returns the serial number of the last day of the month before or after a specified number of months.

=HOUR(serial_number)

Converts a serial number to an hour.

=ISOWEEKNUM(date)

Returns the number of the ISO week number of the year for a given date.

=MINUTE(serial_number)

Converts a serial number to a minute.

=MONTH(serial_number)

Converts a serial number to a month.

=NETWORKDAYS(start_date, end_date, [holidays])

Returns the number of whole workdays between two dates.

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

=NOW()

Returns the serial number of the current date and time.

=SECOND(serial_number)

Converts a serial number to a second.

=TIME(hour, minute, second)

Returns the serial number of a particular time.

=TIMEVALUE(time_text)

Converts a time in the form of text to a serial number.

=TODAY()

Returns the serial number of today's date.

=WEEKDAY(serial_number, [return_type])

Converts a serial number to a day of the week.

=WEEKNUM(serial_number, [return_type])

Converts a serial number to a number representing where the week falls numerically with a year.

=WORKDAY(start_date, days, [holidays])

Returns the serial number of the date before or after a specified number of workdays.

=WORKDAY.INTL(start_date, days, [weekend], [holidays])

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

=YEAR(serial_number)

Converts a serial number to a year.

=YEARFRAC(start_date, end_date, [basis])

Returns the year fraction representing the number of whole days between start_date and end_date.