Range Names

W

Wes

I need to figure out how to automatically assign dynamic range names to
each "Saturday to Friday" in a list of monthly day numbers and associated
day names for an entire year.

A B
1 Sat
2 Sun
3 Mon
4 Tue
5........etc.
I don't know where to start.
Thanks,
Wes
 
N

Norman Jones

Hi Wes,

Depending on what you wish to do, XL's built in WeekNum function may assist.
 
W

Wes

Thanks,

Is there a way to include the WeekNum results into a formula/function that
would define dynamic range names?
Wes
 
Top