DATE
Returns the serial number of a particular date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
Date & Time
Date & Time functions help you calculate with dates, times, and business calendars.
They are essential for reporting periods and time-based analysis.
Often combined with logical conditions and lookups.
Tips
- Ensure values are real dates, not text.
- Use business-day functions when relevant.
Excel functions in this category (25)
DATEDIF
Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
Date & TimeDates & Time Calculations
DATEVALUE
Converts a date in the form of text to a serial number.
Date & TimeDates & Time Calculations
DAY
Converts a serial number to a day of the month.
Date & TimeDates & Time CalculationsMost Used
DAYS
Returns the number of days between two dates.
Date & TimeDates & Time Calculations
DAYS360
Calculates the number of days between two dates based on a 360-day year.
Date & TimeDates & Time Calculations
EDATE
Returns the serial number of the date that is the indicated number of months before or after the start date.
Date & TimeDates & Time Calculations
EOMONTH
Returns the serial number of the last day of the month before or after a specified number of months.
Date & TimeDates & Time Calculations
HOUR
Converts a serial number to an hour.
Date & TimeDates & Time Calculations
ISOWEEKNUM
Returns the number of the ISO week number of the year for a given date.
Date & TimeDates & Time Calculations
MINUTE
Converts a serial number to a minute.
Date & TimeDates & Time Calculations
MONTH
Converts a serial number to a month.
Date & TimeDates & Time CalculationsMost Used
NETWORKDAYS
Returns the number of whole workdays between two dates.
Date & TimeDates & Time Calculations
NETWORKDAYS.INTL
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.
Date & TimeDates & Time Calculations
NOW
Returns the serial number of the current date and time.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
SECOND
Converts a serial number to a second.
Date & TimeDates & Time Calculations
TIME
Returns the serial number of a particular time.
Date & TimeDates & Time Calculations
TIMEVALUE
Converts a time in the form of text to a serial number.
Date & TimeDates & Time Calculations
TODAY
Returns the serial number of today's date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
WEEKDAY
Converts a serial number to a day of the week.
Date & TimeDates & Time CalculationsMost Used
WEEKNUM
Converts a serial number to a number representing where the week falls numerically with a year.
Date & TimeDates & Time CalculationsMost Used
WORKDAY
Returns the serial number of the date before or after a specified number of workdays.
Date & TimeDates & Time Calculations
WORKDAY.INTL
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.
Date & TimeDates & Time Calculations
YEAR
Converts a serial number to a year.
Date & TimeDates & Time CalculationsMost Used
YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date.
Date & TimeDates & Time Calculations