Dates & Deadlines
Overdue flags, days remaining, due dates, and date math.
Calculate Days Overdue
Subtract the due date from today to see how many days late each item is — clamped to zero so future dates don't go negative.
=MAX(0,TODAY()-B2)Flag Overdue Tasks Automatically
Mark a task Overdue when its due date has passed and it isn't complete, using IF with AND — the backbone of every tracker.
=IF(AND(B2<TODAY(),C2<>"Complete"),"Overdue","On Track")Calculate Days Remaining Until a Due Date
Subtract today from the due date to count down the days left — clamped to zero so past-due items don't show negative numbers.
=MAX(0,B2-TODAY())Group Dates by Month with a Helper Column
Turn each date into a "2026-07" label with TEXT so you can pivot, sort, and subtotal by month — the setup step behind every monthly report.
=TEXT(B2,"yyyy-mm")Calculate the Days Between Two Dates
Subtract one date from another to count the days between them — order to delivery, invoice to payment, project start to finish.
=B2-A2Count Business Days Between Two Dates
NETWORKDAYS counts only Monday-to-Friday days between two dates — the right math for SLAs, payment terms, and turnaround times.
=NETWORKDAYS(A2,B2)Add Business Days to a Date
WORKDAY jumps forward a set number of working days, skipping weekends — ideal for promised ship dates and payment-terms deadlines.
=WORKDAY(A2,10)Get the Month Name From a Date
TEXT with the "mmmm" format turns any date into its month name — July, not 7 — for report labels and monthly groupings.
=TEXT(A2,"mmmm")Get the Quarter From a Date
Turn any date into Q1–Q4 with one formula — divide the month by 3 and round up — for quarterly sales, pipeline, and budget rollups.
="Q"&ROUNDUP(MONTH(A2)/3,0)Find the Last Day of the Month for Any Date
EOMONTH returns the month-end date for any date — the standard tool for billing cutoffs, month-end close, and end-of-month due dates.
=EOMONTH(A2,0)Get the First Day of the Next Month
EOMONTH plus one day lands on the 1st of the following month — the clean way to compute billing starts and new-period kickoff dates.
=EOMONTH(A2,0)+1Check Whether a Date Falls on a Weekend
WEEKDAY with return type 2 numbers the week Monday=1 to Sunday=7, so anything above 5 is a weekend — one IF turns that into a label.
=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")TODAY vs NOW: Which Date Function to Use
TODAY returns just the date; NOW adds clock time that breaks date comparisons — use TODAY for deadlines, NOW only when the hour matters.
=TODAY()Calculate Years Between Two Dates
DATEDIF returns completed years between two dates — the standard way to compute age, tenure, or account lifetime from a start date.
=DATEDIF(B2,TODAY(),"Y")