Auto populate calendar week with starting Monday

Although i have been a member for a while i have never posted a questions.

This is my issue.
I am trying to auto populate a calendar. The one posted by Pete_Uk work great except I would like them to display Monday as the 1st day instead of Sunday.

The solution should be simple but i can't get it to work correctly.

His ef89_scheduler has the year in Z5 and the month in Z4.
The formula in B2 for Sunday is =IF(WEEKDAY(DATE($Z5,$Z4,1))>1,"",DATE($Z5,$Z4,1))
and then for the weekdays formula such as =IF(B2<>"",B2+1,IF(WEEKDAY(DATE($Z5,$Z4,1))>2,"",DATE($Z5,$Z4,1)))
and then for Saturday =IF(S2<>"",S2+1,DATE($Z5,$Z4,1))

Can anyone help me with the modifications that i need to get this to work for me.
your help would be very much appreciated

Try

Change your headings to Monday==>Sunday

and change WEEKDAY function in all cells as shown (highiighted) below

=IF(WEEKDAY(DATE($Z5,$Z4,1),2)>1,"",DATE($Z5,$Z4,1))

thank you for your help, as you requested i have attached the file that i am working with, which was originally posted by Pete_uk on your site,

this files which works great, except that I want the days of the week to be 'Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday'
Pete_uk file uses Sunday as the start of the week

a big thank you John.

after you replied yesterday i tried it and it didn't seem to work for me.
but your file works great. Now i will compare to see where i went wrong.

thank again

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.