I have been playing round with the WEEKDAY function to convert dates in the
format 1-Apr-06 to digits referring to the day of the week (i.e. 1 to 7).
What is the best way to easily convert these numbers into the actual days of
the week (Monday, Tuesday).

Can I use teh IF function- I started to try this but got a bit stuck:
=IF(WEEKDAY($B2) =1,"Sunday"........

Cheers,

Create a named table, DOW to refer to a 7 cell list with the days in them

Then where ever you need day of week as a text string
use =INDEX(DOW,WEEKDAY(B2))

Alternatively if you just want to see The day of the week, then

Format the cell as Custom dddd
and just reference the cell with the date
ie = b2

Steve



On Thu, 01 Feb 2007 11:50:00 -0000, kippers
wrote:

I have been playing round with the WEEKDAY function to convert dates in
the
format 1-Apr-06 to digits referring to the day of the week (i.e. 1 to 7).
What is the best way to easily convert these numbers into the actual
days of
the week (Monday, Tuesday).

Can I use teh IF function- I started to try this but got a bit stuck:
=IF(WEEKDAY($B2) =1,"Sunday"........

Cheers,

=TEXT(A10,"DDDDD")

where A10 is the date

"kippers" wrote:

I have been playing round with the WEEKDAY function to convert dates in the
format 1-Apr-06 to digits referring to the day of the week (i.e. 1 to 7).
What is the best way to easily convert these numbers into the actual days of
the week (Monday, Tuesday).

Can I use teh IF function- I started to try this but got a bit stuck:
=IF(WEEKDAY($B2) =1,"Sunday"........

Cheers,

=CHOOSE(WEEKDAY(A1,2),"Monday","Tuesday","Wednesda y","Thursday","Friday","","")

"SteveW" wrote in message
news:op.tm2jvblwevjsnp@enigma03:

Create a named table, DOW to refer to a 7 cell list with the days in them

Then where ever you need day of week as a text string
use =INDEX(DOW,WEEKDAY(B2))

Alternatively if you just want to see The day of the week, then

Format the cell as Custom dddd
and just reference the cell with the date
ie = b2

Steve



On Thu, 01 Feb 2007 11:50:00 -0000, kippers
wrote:

I have been playing round with the WEEKDAY function to convert dates in
the
format 1-Apr-06 to digits referring to the day of the week (i.e. 1 to 7).
What is the best way to easily convert these numbers into the actual
days of
the week (Monday, Tuesday).

Can I use teh IF function- I started to try this but got a bit stuck:
=IF(WEEKDAY($B2) =1,"Sunday"........

Cheers,