Automatic Calendar

[GhostWatch]

Im making an automatics calendar where the months are separate and weeks are Monday to Sunday.
I use this to find the weeknumber within the month and it resets for each month.

=ISOWEEKNUM(A364)-ISOWEEKNUM(DATE(YEAR(A364),MONTH(A364),1))+1

However for the end of December it no longer works and gives an error.
Each month is set out as below but as you can see the dates do not carry on until the month end.

If i use

=WEEKNUM(A364,2)-WEEKNUM(DATE(YEAR(A364),MONTH(A364),1),1)+1


then if the week doesn't start on a Sunday, then it leaves an empty row in the calendar under the days.
How would i go about fixing this?

 

[FormR]

Hi, welcome to the forum!

If I've understood correctly, you could try with this:

=INT((A364-WORKDAY.INTL(DATE(YEAR(A364),MONTH(A364),2),-1,"0111111"))/7)+1