I am currently working on a project that associates 6 cycle weeks with a particular rate month, e.g. cycles 1-6 correspond to jan-17 rate month, cylces 7-12 correspond to feb-17 rate month, etc. There are a total of 72 cycles per year that are associated with 12 months per year. Currently i have manually associated each rate month with its respective cycle week. I was looking for a way to use a formula that would make it more dynamic.
I have attached a spreadsheet with the data that i am working with. I am looking for the formula to be place in column B. I also have a section that associates the rate month and the last cycle in each rate month in columns D & E.
Thank you for all your help.