Planned monthly works formula/VBA

[KBExcelNoob]

Hi,

I created a spreadsheet that will create a yearly planner for works every Nth amount of days, this works perfectly for weekly planned work but not monthly.

where as a weekly is just =IF(MOD(COLUMN to 7 places, each month has a different amount of days in it.


Is there a simple way to select Nth column where N is variable for each selection? The I could just input the different days of each month.

Even better, has anyone else created a spreadsheet that allows for the input of a start date, with weekly, monthly, quarterly, annual planning that will then make this visible on 1 sheet for multiple works?


Any thoughts on this are welcome, I understand formulas to a reasonable level and VBA I can edit slightly but cannot write them myself.


Regards,
KBExcelNoob

[JeteMc]

Hello KBExcelNoob and Welcome to Excel Forum.

I created a spreadsheet that will create a yearly planner for works every Nth amount of days, this works perfectly for weekly planned work but not monthly.

It may help someone to better assist you if you would upload the spreadsheet mentioned above, instructions are given in the banner at the top of the page.
Let us know if you have any questions.