Formula or VBA -Schedule

Hi All,Have partly done what I need with formula and Conditional Formatting I need the table to populate appropriate slots for the week scheduled determined by the given frequency of the task.Cell to have the Frequency number to work with Conditional formatting
Thank you for having a look

Hi

Try this formula in D5 and copy formulas for the entire range (D5:BD16)

Formula:

Please Login or Register  to view this content.

Hi Jose Augusto
Really appreciate you taking a look, will give it a go and let you know, just started trying to do it a very long and repetitious way
Gracias

I got what I wanted to work.Appreciate your help Jose but formula you gave ,I could get to work, probably me ,not your work I would think

Cycle of 1 (Daily) 7(weekly) Days
(14)2 weeks,(30)4 weeks,(60)8 weeks,(90)12 weeks (120)etc(180)etc(365)etc
I can select the week of year to commence cycle so that weekly loads can be adjusted, and when I do,change that number, the whole row adjusts to keep that frequency
I would be interested to know if it could have been done easier, instead of having a worksheet for each days cycle ie 1,7,14,30 etc etc
Thank you for taking the time to have a look

Hi @Peteraskeeta

I use a table to get the number of weeks in BG4:BH12
The formula must be updated to

Formula:

Please Login or Register  to view this content.

See the file for clarification.

Regards

thank you Jose will give it a go