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, 20178 yr by John Chamberlain
correction

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 )
)

 

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.