date ca First Monday Calculation

[John Chamberlain]

I need a calculation that will return the day number (1st, 2nd, etc) for the first Monday in a given month (e.g. an input of 9/2017 would return "4")

Any help is gratefully appreciated.

Edited August 22, 2017 by John Chamberlain
correction

[comment]

You could have deduced this from the answer to your previous question. The date of the first Monday in a given month is =

Let ( [
firstDayOfMonth = Date ( Month ; 1 ; Year ) ;
diff = 2 - DayOfWeek ( firstDayOfMonth ) 
] ;
firstDayOfMonth + Mod ( diff ; 7 )
)

 

[John Chamberlain]

Thanks for your help.

I never saw an answer to my previous question because, even though I checked the "Notify me of replies" box, no email was ever sent.

I checked that same box for this question and no message came through for your answer either.