Range Names

  • Thread starter Thread starter Wes
  • Start date Start date
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
 
Hi Wes,

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

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