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
|