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.

February 2026 starts on Sunday, so the Monday target is February 2.

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.

June 1, 2026 is Monday and needs zero days added.

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

Microsoft’s Excel function reference