DATE
Returns the serial number of a particular date.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
Dates & Time Calculations
Dates & Time Calculations are essential for planning, reporting, SLAs, and time-series analysis. These functions help you add, compare, and format dates safely.
This collection groups Excel functions that are commonly used for dates & time calculations workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (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