🚀 Project Planner

Goal: Calculate a Deadline 5 business days from Start.
WORKDAY skips Weekends (Sat/Sun) and Holidays.

OCTOBER 2025
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Ready...

💻 Formula Structure

=WORKDAY(start_date, days, [holidays])
  • 1. Start Date: Project start (Oct 1).
  • 2. Days: Business days to add (5).
  • 3. Holidays: Optional list of dates to skip.
-- Oct 1st + 5 Working Days (Skip Holiday Oct 8)
=WORKDAY( "Oct 1", 5, "Oct 8" )
Deadline:
-

⚠️ Common Pitfalls

🚫 Custom Weekends
Standard WORKDAY assumes Sat/Sun weekends. If your work week is different (e.g., Fri/Sat off), use WORKDAY.INTL instead.
🚫 Negative Days
You can use negative numbers (e.g., -5) to count backwards in time, finding a start date from a deadline.