DAYS Function in Excel: Days Between Two Dates
DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.
Read article →Date & Time
Excel Date & Time functions explained with syntax, examples and common mistakes.
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC Function in Excel: Fraction of a Year Between Dates
YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.
Read article →WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY Function in Excel: A Date N Working Days Away
WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.
Read article →NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS Function in Excel: Working Days Between Two Dates
NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.
Read article →DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF Function in Excel: Age and Tenure in Years, Months, Days
DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.
Read article →EDATE Function in Excel: Add or Subtract Months From a Date
EDATE Function in Excel: Add or Subtract Months From a Date
EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.
Read article →EOMONTH Function in Excel: Last Day of a Month
EOMONTH Function in Excel: Last Day of a Month
Date & TimeLevel: IntermediateAvailable in: Excel 2007+EOMONTH returns the last day of the month, a number of months away from a.
Read article →YEAR Function in Excel: Year From a Date
YEAR Function in Excel: Year From a Date
YEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month (1–12) and day (1–31).
Read article →MONTH Function in Excel: Month Number From a Date
MONTH Function in Excel: Month Number From a Date
MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.
Read article →WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY Function in Excel: Day of the Week as a Number
WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…
Read article →DATE Function in Excel: Build a Date From Year, Month and Day
DATE Function in Excel: Build a Date From Year, Month and Day
DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.
Read article →WEEKNUM Function in Excel: Week Number of the Year
WEEKNUM Function in Excel: Week Number of the Year
WEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains the first Thursday).
Read article →