A monthly stock check runs on the first Monday, even when the month starts on Monday itself. Start from any date in the month and calculate the first day before looking for the weekday.
Reduce the input to the first of its month
With a date from the target month in A2, put this in B2:
=DATE(YEAR(A2),MONTH(A2),1)Enter the result formula in C2 and format it as a date.
=B2+MOD(8-WEEKDAY(B2,2),7)WEEKDAY(B2,2) counts Monday as 1 and Sunday as 7. The MOD expression returns an offset from zero through six.

Illustrated calendar check. First reduce the input to the first day of its month.
Check Sunday and Monday starts
For February 2026, the first is a Sunday, so the formula adds one day and returns February 2. For June 2026, the first is already Monday. The offset is zero and the formula returns June 1. A later holiday adjustment belongs in a separate rule if your schedule uses one.

Illustrated boundary case. MOD keeps the offset within zero through six days.



