Dates & Times
Get the Year from a Date in Excel (YEAR, and grouping by year)
Extract the year from a date in Excel with YEAR, as text with TEXT, the fiscal year, and total or count by year with SUMIF and a pivot.
Category: Dates & Times
Dates & Times
How to Calculate Hours Worked in Excel (timesheet with breaks and overtime)
Calculate hours worked in Excel from start and end times, subtract a break, total a week correctly past 24 hours, convert to decimal for pay, and add overtime.
Dates & Times
Get the Quarter from a Date in Excel (Q1–Q4, and fiscal quarters)
Get the quarter from a date in Excel with one formula, show it as Q3 2026, handle a fiscal year starting in April, and total sales by quarter.
Dates & Times
Years Between Two Dates in Excel (whole years, or decimal)
Calculate years between two dates in Excel: whole years with DATEDIF, decimal years with YEARFRAC, years and months together, and service length for a list.
Dates & Times
Excel Week Number: WEEKNUM, ISO weeks, and grouping by week
Get the week number in Excel with WEEKNUM, the ISO week that matches most calendars, the week's start date, and totals per week with SUMIF.
Dates & Times
Add Months to a Date in Excel (EDATE, and end-of-month)
Add months to a date in Excel with EDATE, subtract months, land on the last day of the month with EOMONTH, and add years or days the same way.
Dates & Times
How to Calculate Age in Excel from a Date of Birth
Calculate age in Excel from a birth date with DATEDIF: years only, years and months, age on a specific date, and why YEARFRAC rounds wrong.
Dates & Times
Convert Text to Date in Excel: 3 fixes that always work
Convert text to real dates in Excel with Text to Columns, DATEVALUE, or DATE with pieces — for dd/mm/yyyy, 20260929, and dates with dots.
Dates & Times
How to Sort by Date in Excel (and why it sorts wrong)
Sort by date in Excel oldest to newest, keep rows together, sort by month ignoring the year, and fix the sort when dates are stored as text.
16 tutorials · Page 1 of 2
