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.
Live Score Feedback
Active Logic Validation
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
Returns the day-of-week number for a date.
Weeknum Function
Returns the week number for a date.
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
Extracts the year number from a valid Excel date.
Yearfrac Function
Returns the fraction of a year between two dates using a selectable day-count basis.
"This expertise path is engineered for maximum logic retention. We use interactive simulations to ensure every advanced function is immediately applied to real-world datasets."