Bob Phillips wrote:
something like

=IF(INDIRECT("Data"&WEEKDAY(TODAY()))100, "Yes","No")

Thanks a bunch, Bob!! I actually was trying to get the contents of
the named range to appear so I did

=INDIRECT("Data"&WEEKDAY(TODAY()))

and it worked like a charm. Thanks a MILL! I am just a casual user
of Excel so I never would've figured this out on my own.

(on the 8th day, Dog created newsgroups...)

Rose