Date and Time Functions

Functions for date and time calculations

DATE Function

The DATE function constructs a valid date from individual year, month, and day components, returning Excel's serial number representation. Perfect for building dates from separate cells or calculations, handling overflow intelligently by adjusting months and years automatically.

DATEDIF Function

The DATEDIF function calculates the precise difference between two dates in years, months, or days. It's particularly useful for age calculations, service tenure tracking, and project duration analysis, offering specialized units beyond simple date subtraction.

DATEVALUE Function

The DATEVALUE function converts text strings representing dates into Excel serial numbers that can be used in date calculations, sorting, filtering, and formatting. This is essential when working with imported data or text-formatted dates that Excel doesn't automatically recognize as dates.

DAY Function

The DAY function extracts the day component from any date value in Excel, returning an integer between 1 and 31. Perfect for date analysis, reporting, and dynamic calculations that depend on the specific day of the month.

DAYS Function

The DAYS function calculates the exact number of calendar days between two dates, making it perfect for tracking project durations, age calculations, or any time span measurement in Excel.

DAYS360 Function

The DAYS360 function calculates the number of days between two dates using a standardized 360-day year (12 months of 30 days each). This method is commonly used in financial and accounting calculations for loan interest, bond pricing, and payment schedules.

EDATE Function

The Excel EDATE function returns a date that is a specified number of months before or after a start date. Perfect for calculating maturity dates, due dates, or any date that needs to maintain the same day of the month.

EOMONTH Function

The EOMONTH function returns the last day of the month that is a specified number of months before or after a given start date. Perfect for calculating month-end dates, maturity dates, due dates, and fiscal period endings.

HOUR Function

The Excel HOUR function extracts the hour component from a time value, returning an integer from 0 (12:00 A.M.) to 23 (11:00 P.M.). Perfect for time analysis and scheduling tasks.

ISOWEEKNUM Function

The ISOWEEKNUM function returns the ISO week number of the year for a specified date, following the ISO 8601 standard where weeks start on Monday and the first week of the year contains at least 4 days.

MINUTE Function

The Excel MINUTE function extracts the minute component from a time value, returning an integer between 0 and 59. It's essential for time analysis, scheduling, and breaking down datetime values into individual components for calculations and reporting.

MONTH Function

The Excel MONTH function extracts the month number from any date value, returning an integer between 1 (January) and 12 (December). This is essential for date analysis, reporting, and conditional logic based on months.

NETWORKDAYS Function

The Excel NETWORKDAYS function calculates the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and any specified holidays. Perfect for project planning, employee tenure calculations, and business day counting.

NETWORKDAYS.INTL Function

The NETWORKDAYS.INTL function calculates the number of working days between two dates, allowing customization of weekend days and exclusion of holidays. Unlike the standard NETWORKDAYS function, it supports international workweek patterns and flexible weekend definitions.

NOW Function

The Excel NOW function returns the current date and time as a serial number, formatted according to your regional settings. This dynamic function updates automatically when the worksheet recalculates, making it perfect for timestamps, deadline tracking, and time-based calculations.

SECOND Function

The Excel SECOND function extracts the seconds component from a given time value, returning an integer between 0 and 59. It's perfect for time analysis, logging, and breaking down timestamps into individual components.

TIME Function

The Excel TIME function converts separate hour, minute, and second values into a single time serial number that Excel recognizes as a time value. This creates a decimal fraction of a day representing the specified time.

TIMEVALUE Function

The Excel TIMEVALUE function converts a time represented as text into its decimal number equivalent, representing the fraction of a 24-hour day. This is essential for performing mathematical operations on time values extracted from text data.

TODAY Function

The TODAY function returns the current date as a serial number, automatically updating whenever the workbook recalculates. Excel automatically formats the result as a date, making it perfect for dynamic date displays, age calculations, and time interval computations.

WEEKDAY Function

The WEEKDAY function in Excel returns a number representing the day of the week for a given date. By default, it assigns 1 to Sunday through 7 to Saturday, but offers flexible numbering systems via the return_type parameter for various analytical needs.

WEEKNUM Function

The Excel WEEKNUM function extracts the week number from any given date, enabling effective date-based analysis, reporting, and timeline organization across various week numbering systems.

WORKDAY Function

The WORKDAY function calculates a future or past date that is a specified number of working days from a start date, automatically excluding weekends (Saturday and Sunday) and any specified holidays. Perfect for project timelines, delivery schedules, and invoice due dates.

WORKDAY.INTL Function

The WORKDAY.INTL function calculates dates that are a specified number of working days before or after a start date, with customizable weekend definitions. This advanced date function lets you define which days count as weekends, making it perfect for international scheduling and custom work calendars.

YEAR Function

The Excel YEAR function extracts the year from any date value, returning it as an integer between 1900 and 9999. It's essential for date analysis, grouping data by year, and creating dynamic reports based on date components.

YEARFRAC Function

YEARFRAC calculates the precise fraction of a year between two dates, essential for financial calculations like prorated interest, benefits accrual, or obligations based on actual time periods.