Date & Time
Next Specific Weekday
Find the date of the next specific weekday (e.g., next Monday, next Friday) from a given date. Useful for scheduling and planning.
Excel Formula
=A2-WEEKDAY(A2-B2)+7Step-by-Step Explanation
1
A2 is the starting date
2
B2 is the target weekday number (1=Sunday, 2=Monday... 7=Saturday)
3
WEEKDAY(A2-B2) calculates days since last occurrence of the target day
4
Adding 7 ensures we get the NEXT occurrence, not the current/past one
5
Adjust if the target day is today and you want today's date
Example
| Current Date (A) | Day# (B) | Next Occurrence (C) |
|---|---|---|
| 3/18/2026 (Wed) | 2 (Mon) | 3/23/2026 (Mon) |
| 3/18/2026 (Wed) | 6 (Fri) | 3/20/2026 (Fri) |
Result: =A2-WEEKDAY(A2-2)+7 → Next Monday
Common Variations
Next Monday specifically
=A2+(9-WEEKDAY(A2,2))Simplified for Monday
Next or same day
=A2-WEEKDAY(A2-B2)+IF(WEEKDAY(A2)=B2,0,7)Returns today if it matches
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →