Date & Time functions in Excel empower users to manage, analyze, and calculate time-based data with accuracy and flexibility — without the need for complex programming. These essential tools make it easy to extract components of dates, calculate time intervals, build dynamic schedules, and automate calendar-based logic directly within Excel. Whether you’re tracking deadlines, calculating aging reports, generating time-sensitive dashboards, or building date-driven workflows, Excel’s date and time functions allow users to transform chronological data into actionable insights. By leveraging these capabilities, professionals can streamline operations, ensure temporal accuracy, and support smarter, time-aware decision-making across a wide range of business scenarios.
This function calculates the fraction of a year between two dates, useful for financial calculations and comparisons. Syntax: YEARFRAC(start_date, end_date, [basis]) Arguments: start_date (required): The beginning date of the period end_date (required): The ending date of the period basis (optional): The day count
This function extracts the four-digit year (1900–9999) from a date value. Syntax: YEAR(serial_number) Arguments: serial_number (required): The date from which to extract the year. This can be: A date serial number A reference to a cell containing a date A date
This advanced function calculates a date before or after a specified number of workdays, with customizable weekend days and optional holiday exclusions. Syntax: WORKDAY.INTL(start_date, days, [weekend], [holidays]) Arguments: start_date (required): Beginning date for calculation (serial number or date text) days (required): Number
This function calculates the date that is a specified number of workdays before or after a start date, excluding weekends and optional holidays. Syntax: WORKDAY(start_date, days, [holidays]) Arguments: start_date (required): The beginning date for the calculation days (required): Number of workdays to
This function returns the week number (as an integer) for a given date. Syntax: WEEKNUM(serial_number, [return_type]) Arguments: serial_number (required): The date for which to calculate the week number. return_type (optional): A number specifying the week numbering system and starting day. Options in
This function converts a date (serial number) into a weekday number, returning an integer from 1 (Sunday) to 7 (Saturday) by default. Syntax: WEEKDAY(serial_number, [return_type]) Arguments: serial_number (required): The date for which to calculate the weekday number. return_type (optional): A number (1, 2, or 3) that determines the
This function returns the serial number corresponding to the current date. Syntax: TODAY() Background: The TODAY() function retrieves the current date without including the time. If the cell is formatted as General before entering the function, the result will display as a date. The
This function converts a time formatted as text into a time value (serial number). The serial number is a value in the range of 0 through 0.99999999, corresponding to a time from 00:00:00 through 23:59:59. Syntax: TIMEVALUE(time_text) Arguments: Time_text (required): A text value in any Excel time
This function returns the serial number (decimal value) representing a time specified by the hour, minute, and second arguments. Syntax: TIME(hour, minute, second) Arguments: hour (required) – A number from 0 to 32,767 representing the hour. Values > 23 are divided by 24, and the remainder is used as the
This function extracts the seconds from a serial number (a time value, with or without a date). The returned value is an integer between 0 and 59. Syntax: SECOND(serial_number) Arguments: serial_number (required) – A valid time (or a date-time value). Background  Like the HOUR() and MINUTE() functions, SECOND() allows you to extract
It is use to calculates the number of working days between two dates while excluding: Custom-defined weekends (not limited to Saturday/Sunday) Specified holidays Syntax NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) Arguments start_date (required): First day of the period. end_date (required): Last day of the period. weekend (optional):
The NETWORKDAYS function is use to calculates the number of working days between two dates, automatically excluding: Weekends (Saturday & Sunday) Custom holidays (if specified) Syntax NETWORKDAYS(start_date, end_date, [holidays]) Arguments start_date (required): First day of the period. end_date (required): Last day of the period. holidays (optional):
Its extracts the month number (1-12) from a date, where: 1 = January 12 = December Syntax MONTH(serial_number) Arguments serial_number (required): A valid date Can be: A date string (e.g., « 11/14/1959 ») A serial number (Excel date format) A cell reference containing a date The result of another function (e.g., TODAY()) Background Part of Excel’s date
The MINUTE function is use to extracts the minute component from a time value (with or without an associated date). Returns an integer between 0 and 59. Syntax MINUTE(serial_number) Arguments serial_number (required): A valid time value Can be entered as: A time string in quotes (e.g., « 06:43 ») A decimal
Its extracts the hour component from a time value (with or without an associated date). Returns an integer between 0 (midnight) and 23 (11 PM). Syntax HOUR(serial_number) Arguments serial_number (required): A valid time value Can be entered as: Time string in
Excel offers far more than just basic formulas. Beyond the Date & Time functions, there’s a powerful universe of functions designed to help you analyze data, automate tasks, and build dynamic spreadsheets. In this section, you’ll discover key categories such as lookup functions, logical functions, text manipulation, financial formulas, and more — each with clear explanations and real-world examples to help you master them with confidence.
