Date & Time Functions
Master 27 Excel date and time functions like TODAY, NOW, DATE, DATEDIF, and NETWORKDAYS with interactive exercises. Manage schedules and calculate durations efficiently.
Instant Feedback
Live Answer Checking
Industry Datasets
Date & Time Functions Foundations
Learn how Excel stores dates and times, how core date functions are grouped, and how to use them in practical worksheet workflows.
Date Function
Build valid Excel dates from separate year, month, and day values. DATE is one of the safest ways to create reliable dates in formulas.
Datedif Function
Calculate completed years, months, or days between two dates. DATEDIF is useful when you need full units instead of rough date subtraction.
Datevalue Function
Convert a date stored as text into a real Excel date value. DATEVALUE is useful when imported dates look correct but still behave like text.
Day Function
Extract the day of the month from a date. DAY is useful when you need the 1-31 part of a date for recurring logic and date-based checks.
Days Function
Calculate the number of calendar days between two dates. DAYS is useful when you need a straight day count without removing weekends or holidays.
Days360 Function
Calculate the difference between two dates using a 360-day year with twelve 30-day months. DAYS360 is mostly used in accounting and finance models that follow that convention.
Edate Function
Move a date forward or backward by a whole number of months. EDATE is useful for renewals, due dates, anniversaries, and month-based schedules.
Eomonth Function
Returns the last day of the month before or after a given date.
Hour Function
Extract the hour component (0-23) from a valid time serial. The essential tool for auditing labor shifts, identifying peak-load traffic, and deconstructing system timestamps in professional enterprise models.
Interval Function
Formats a total number of seconds as a readable interval string.
Isoweeknum Function
Returns the ISO 8601 week number for a date, using Monday-based weeks and the ISO week 1 rule.
Minute Function
Extracts the minute component from a valid Excel time value.
Month Function
Extracts the month number from a valid Excel date.
Networkdays Function
Counts the number of working days between two dates, excluding weekends and optional holidays.
Networkdays.intl Function
Counts working days between two dates using custom weekend rules and optional holidays.
Now Function
Returns the current date and time as a dynamic Excel date-time value.
Second Function
Extracts the second component from a valid Excel time value.
Time Function
Builds a valid Excel time value from separate hour, minute, and second inputs.
Timevalue Function
Converts a text time into a valid Excel time value.
Today Function
Returns the current date as a dynamic Excel date value.
Weekday Function
Find the day of the week for any date in Excel using WEEKDAY. Master return type arguments and practice interactive worksheet challenges.
Weeknum Function
Calculate the week number of a specific date in Excel with WEEKNUM. Learn date numbering systems and practice hands-on formula exercises.
Workday Function
Returns a workday date before or after a start date, skipping weekends and optional holidays.
Workday.intl Function
Returns a workday date before or after a start date using custom weekend rules and optional holidays.
Year Function
Extract the four-digit year from any valid Excel date with YEAR. Practice date manipulation and formatting formulas in interactive spreadsheet lessons.
Yearfrac Function
Returns the fraction of a year between two dates using a selectable day-count basis.
Dates and timestamps in Excel are serial numbers that require precise handling for business reporting, project timelines, and SLA tracking. Master dynamic interval calculations using DATEDIF, YEARFRAC, DAYS, and end-of-period offsets with EOMONTH and EDATE.
Build production-ready payroll and milestone trackers with custom business calendar logic using NETWORKDAYS.INTL and WORKDAY.INTL, accounting for regional weekends and company holidays.