Guides
Date math sounds simple until weekends, holidays, and month-ends get involved. These guides explain how the calculations work — and how to get the right answer with Date Math in seconds.
How to Calculate Business Days
What counts as a business day, how weekends and public holidays change the math, and how to add or count working days correctly.
Read the guideHow to Count the Days Between Two Dates
Inclusive vs. exclusive counting, converting days into weeks, and the everyday questions a days-between calculation answers.
Read the guideAdding and Subtracting Days, Weeks, and Months
How date arithmetic really works, the month-end edge cases that trip people up, and when to switch to business-day mode.
Read the guideFinding the End of a Month, Quarter, or Year
Locate period boundaries and the next weekday or business day — the dates that drive billing cycles, payroll, and reporting.
Read the guide