To find how many days until Juneteenth (June 19, 2025) from today (Saturday, May 17, 2025), excluding weekends (Saturdays and Sundays), follow this approach:
- Count the total calendar days from May 17, 2025, to June 19, 2025.
- May 17 to May 31 = 15 days
- June 1 to June 19 = 19 days
- Total = 34 calendar days
- Calculate how many weekend days fall within this period.
- There are about 4 full weeks plus some extra days.
- Each full week has 2 weekend days, so 4 weeks × 2 = 8 weekend days.
- Check the leftover days for additional weekends (May 17 is Saturday, so weekends are May 17, 18, 24, 25, 31, June 1, 7, 8, 14, 15).
- Counting these weekends, there are 10 weekend days total.
- Subtract weekend days from total days:
- 34 total days - 10 weekend days = 24 business days (weekdays) until Juneteenth.
Therefore, there are 24 weekdays (business days) until Juneteenth on June 19, 2025, excluding weekends
. If you want to calculate this precisely or for other date ranges, you can use tools like the NETWORKDAYS function in Excel or online business day calculators, which automatically exclude weekends and optionally holidays
