No, I don't understand what you're trying to do, but I thought that the
question was how to get the day of the week, given a date in another cell.
That was what I answered. If someone else has a different understanding as
to what you are trying to ask, they will hopefully answer.
--
David Biddulph

"kathy" wrote in message
...
ok we'll start over...as per previous query I needed cell I 13 on sheet 1
to
reference cell E11 on sheet one which drew ifs info from a drop down list
on
sheet 2 A1:A57 and the day of the week in H3 on sheet 1 and return a route
#
from sheet 2..H1:N57 so the formula below was provided and it is working
upto
input dates of Thursday after which it will not provide the route number..
my
query was if I have to type in the day of the week for the reference is
there any way to have a date formulated cell provide that as each sheet
has
to be dated with specifics say Oct 10 then friday to give me the correct
route #.. sorry it is really hard to put this on paper but hopefully you
can
understand what I need..

"David Biddulph" wrote:

You know what you're trying to match, but we don't.
--
David Biddulph

"kathy" wrote in message
...
problem after this though it nullifies the index match from cell I13

"David Biddulph" wrote:

If H4 is a real date, rather than text, then H3 can be =H4, formatted
as
dddd (which would mean H3 also contains the date), or =TEXT(H4,"dddd")
if
you want H3 to be text.
--
David Biddulph

"kathy" wrote in message
...
..thanks so much this does work.. I just need one more piece of
advice..
for
the date I had to split off the day of the week from the actual
date..
eg.
H3
has monday h4 has Oct 6.. is there any way that when I put Oct 6 in
H4
monday
can populate in H3?

"kathy" wrote:

Hi.. need help to figure out how to:

two worksheets in same book.. one sheet has list for drop down menu
the
other has an invoice.. on the invoice I need cell I 13 which is to
be
a
route
# to reference E 11 (which has name chosen from a drop down list)
and
then
match the day of the week from the date cell H3.. and return the
route
number from either an exact match from list on other sheet or allow
me
to
choose from a second drop down list eliminating the need to match
the
date in
above scenario.. hope this makes sense and someone can help.. am
new
to
this
stuff