Uploaded October 2025 | Updated September 2026, 1 week ago

---

Do you need to be able to automatically determine the 1st weekday of a month based on a date input? (e.g. find the first monday in October)
Or do you need to find the Monday on or before a certain date?

In this video, I will show you the formulas for each and then break down how each one works so you can use them more effectively in your own projects.

***** FORMULAS *****
1. =C4+MOD(2-WEEKDAY(C4),7)
2. =(EOMONTH(B8,-1)+1)+MOD(2-WEEKDAY(EOMONTH(B8,-1)+1),7)
3. =B15+(2-WEEKDAY(B15))
4. =(EOMONTH(B19,-1)+1)+(2-WEEKDAY(EOMONTH(B19,-1)+1))