Numbers to text

[Lorrie]

I am trying to produce (Using Excel 2002 XP) a time
card. I need a day of the week, which I have retrieved
using the WEEKDAY function. That give me the day of the
week in a number. Now I need to convert that number into
the actual day of the week. I've tried using a nested
function first for the weekday and then VLOOKUP to
convert that number to an actual day of the week, but I
have not been successful.

Is there an easier way?

 

[Harald Staff]

Yes:
=TEXT(A1,"dddd")

 

[Jason Morin]

No need for WEEKDAY. Simply pull the date into another
cell and custom format that cell as dddd. For example:

1. A1 contains the date. Put =A1 in B1.
2. Click on B1 and press Ctrl+1. Click on Number tab, the
word "Custom", and key in "dddd" (no quotes) to the right.

HTH
Jason
Atlanta, GA

 

[L. Howard Kittle]

Hi Lorrie,

Does this do what you want?

=LOOKUP(B1,{1,2,3,4,5,6,7},{"Mon","Tue","Wed","Thur","Fri","Fri","Sat","Sun"
})

Where your day number is in B1. Might have to change the sequence if Mon is
not day 1.

HTH
Regards,
Howard

 

[Lorrie]

Thank you ever so much Jason - I have been working on
this for hours and your explaination solved my problme in
minutes.