Range Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wes - 27 Jun 2005 11:35 GMT

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

Reply to this Message

Norman Jones - 27 Jun 2005 12:00 GMT

Hi Wes,

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

---
Regards,
Norman

>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
[quoted text clipped - 9 lines]
> Thanks,
> Wes

Reply to this Message

Wes - 27 Jun 2005 15:22 GMT

Thanks,

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

> Hi Wes,
>
[quoted text clipped - 17 lines]
> > Thanks,
> > Wes

Reply to this Message