Welcome to Challenge HQ

Your next Excel mission is here—designed to sharpen your skills in under 10 minutes.

No logins. No fluff. Just you, Excel, and your instincts.

Challenge #5: Due Dates Don't Lie

Your mission:
  • Calculate each project's Due Date based on start date + business days
  • Determine how many Days Remaining using today’s date
  • Assign a Status: On Track, Due Soon, or Past Due
What You'll Need:
  • WORKDAY to skip weekends when calculating deadlines
  • TODAY + NETWORKDAYS to find working days left
  • IFS logic to label project status in real time
Status Logic:
  • ✅ On Track – more than 3 business days left
  • ⚠️ Due Soon – 3 or fewer business days remaining
  • ❌ Past Due – already missed the deadline
Bonus: Apply Conditional Formatting to color-code each status (Green, Yellow, Red). You can also flag older projects or sort by urgency for extra flair.

Here’s How It Works

  • 📅 Tuesday – We post a teaser + tips
  • 📥 Wednesday – The challenge file drops
  • 🎥 Friday – You get a deeper dive (but no spoilers)
  • ✅ Monday – We reveal the full solution

Follow us on Instagram @my90below to make sure you don’t miss the next drop.

Want bonus tips, extra content, and early notice
when the next challenge drops?

Join the 90 Below email crew and get exclusive content delivered to your inbox.