I am trying to convert dates on a worksheet to days of the week. I have been
able to convert to a day of the week # but not a name. I am now trying to
look at the number and return the day of the week. I have tried several
things starting with an IF THEN statement, with my last attempt being
substitute. I can get 1 to work right but I need 7. I saw something in one
of the posts that uses a table, it was for a horoscope chart, but in trying
to do the first step of creating a table, I found I couldn't figure out how
to do that either. Would appreciate any help!

=SUBSTITUTE(BN:BN,5,"Thursday")

The above string works, however I need to add the other 6 arguments for it
to help me. Below is my failed attempt.

=SUBSTITUTE((BN:BN,5,"Thursday")*OR(BN:BN,6,"Frida y"))


--
Julie Holeman
Timber Tops
865-429-0831 x104

http://yourcabin.com

If they're *true* dates, custom format:
dddd
OR
dddd

If they're not, try:

=TEXT(A1,"dddd")

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Julie Holeman" wrote in message
...
I am trying to convert dates on a worksheet to days of the week. I have been
able to convert to a day of the week # but not a name. I am now trying to
look at the number and return the day of the week. I have tried several
things starting with an IF THEN statement, with my last attempt being
substitute. I can get 1 to work right but I need 7. I saw something in one
of the posts that uses a table, it was for a horoscope chart, but in trying
to do the first step of creating a table, I found I couldn't figure out how
to do that either. Would appreciate any help!

=SUBSTITUTE(BN:BN,5,"Thursday")

The above string works, however I need to add the other 6 arguments for it
to help me. Below is my failed attempt.

=SUBSTITUTE((BN:BN,5,"Thursday")*OR(BN:BN,6,"Frida y"))


--
Julie Holeman
Timber Tops
865-429-0831 x104

http://yourcabin.com

Hi Julie

couple of options:
1) use formatting to display the day rather than the date - if you have the
date in A1 and in B1 you want to see the related day, you can type in B1
=A1
then click on the cell choose format / cells / in the numbers tab choose
custom and type in the box
ddd
or
dddd

2) use the text function, again with date in A1 and the desired result in B1
=Text(A1,"dddd")

hope this helps

Cheers
JulieD

"Julie Holeman" wrote in message
...
I am trying to convert dates on a worksheet to days of the week. I have
been
able to convert to a day of the week # but not a name. I am now trying to
look at the number and return the day of the week. I have tried several
things starting with an IF THEN statement, with my last attempt being
substitute. I can get 1 to work right but I need 7. I saw something in
one
of the posts that uses a table, it was for a horoscope chart, but in
trying
to do the first step of creating a table, I found I couldn't figure out
how
to do that either. Would appreciate any help!

=SUBSTITUTE(BN:BN,5,"Thursday")

The above string works, however I need to add the other 6 arguments for it
to help me. Below is my failed attempt.

=SUBSTITUTE((BN:BN,5,"Thursday")*OR(BN:BN,6,"Frida y"))


--
Julie Holeman
Timber Tops
865-429-0831 x104

http://yourcabin.com

You can use TEXT

=TEXT(A1,"dddd")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Julie Holeman" wrote in message
...
I am trying to convert dates on a worksheet to days of the week. I have
been
able to convert to a day of the week # but not a name. I am now trying to
look at the number and return the day of the week. I have tried several
things starting with an IF THEN statement, with my last attempt being
substitute. I can get 1 to work right but I need 7. I saw something in
one
of the posts that uses a table, it was for a horoscope chart, but in
trying
to do the first step of creating a table, I found I couldn't figure out
how
to do that either. Would appreciate any help!

=SUBSTITUTE(BN:BN,5,"Thursday")

The above string works, however I need to add the other 6 arguments for it
to help me. Below is my failed attempt.

=SUBSTITUTE((BN:BN,5,"Thursday")*OR(BN:BN,6,"Frida y"))


--
Julie Holeman
Timber Tops
865-429-0831 x104

http://yourcabin.com