Date Calculation Tips
Date calculations come up constantly—deadlines, billing cycles, project timelines. Knowing the common mistakes helps you get every date right.
Count the Days, Not the Dates
The most common error is double-counting the start date. From Monday to Wednesday is two days apart, not three. Define whether you count the start date first.
Business Days vs Calendar Days
Contracts often specify business days, which exclude weekends and holidays. A five-business-day turnaround can stretch over a full week, so always confirm which calendar you're using.
Month-End and Quarter-End Traps
Adding one month to January 31 can mean February 28 or 29. Decide upfront whether you want end-of-month clamping or strict month arithmetic.
Working Backward
For deadlines, work back from the due date, including review and buffer time. Most late deliveries come from underestimating the work days, not the calendar days.
Date Arithmetic in Spreadsheets
Spreadsheets store dates as serial numbers, so subtracting two date cells gives the number of days directly. Formatting tricks aside, this makes date math reliable when the source data is clean.
For business days, use the spreadsheet's working-day functions and list the holidays your region observes. Automating this removes the most common manual counting errors.
How to Calculate Between Dates
- Pick the start date and end date you want to measure.
- Choose the unit—days, business days, weeks, or months.
- Read the result and confirm whether the start date should be counted.
Use business days for contracts and deadlines, and calendar days for general planning, to avoid the classic off-by-one error.
Quick tip: when a date feels off, recheck the month length and the year. February and leap years cause more calendar errors than any other source. Always double-check the month length and whether the year is a leap year before relying on a date.