# Associating a date with specific group of numbers

• 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.

forum.ozgrid.com/index.php?attachment/71083/

## Files

• Re: Associating a date with specific group of numbers

Put in B2 on Sheet1 and copied down

=INDEX(\$D\$2:\$D\$14,INT((ROW(A1)-1)/6)+1)

• Re: Associating a date with specific group of numbers

thank you very much. it works perfectly.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!