how to create a list that descends numerically after a specified range

I have a list of dates and need to define every 7 days as a week starting a week 1 and descending numerically. I'm doing this as a set up for an INDEX, MATCH function I'm going to write.

I have attached a sample of what I'm trying to achieve

Starting in A2 are a list of dates, starting in B4 I have week 1 listed and want the week 1 listed for the first 7 rows, then week 2 for the next 7 rows, then week 3 and so on.

Trying to figure out an easy way to automate this process so I don't have to type the week, copy it to the next 6 cells and go down the list that way.

Thank you

Put this formula in the first cell that defines Week 1 (i.e. in B4):

="Week "&INT((ROWS($1:1)-1)/7)+1

then copy down.

Hope this helps.

Pete

Works great and accomplishes excellent what I was trying to do,

Thank you for the help Pete

You're welcome - glad it worked for you.

Pete