I've looked around, but can't find if it's possible for me to "Lookup" in
column of cells based on group criteria and automatically add a Range Name
to them.

I'm busilding a business spreadsheet that has numbered day of the month in
column A and the related day name in column B.

A B
1 Sat
2 Sun
3 Mon

I want to do comparisons with previous years same "Weeks", like "week 1",
"week 2", etc. starting from the first Saturday of the year to the last
Friday of the year. I need to figure out how to lookup, group and
automatically assign range names like "week 1", etc. to each "Saturday to
Friday" group. I know I can do it manually by selecting ranges and naming
them, but with multiple years and multiple worksheets I was hoping to make a
template worksheet to use year after year by only needing to changing column
B days for each year in the template. Of course I need to include leap year
and each new year would re-arrange the day's number in relation to the day's
name.

If I could make the worksheet automatically group and name the "Weeks" for
me it would save me and my predissor 52 manual selecting and namings each
year to set up the new years worksheet.

Then I am hoping to use the created range names to lookup data in my
spreadsheets for that "Week".

I just don't know if I can do this in Excel or where to start.

Thanks,

Wes