Hi,

I need to transform a date to week date , for example:
10/11/05 to Tuesday
Is there any formula can do this transform?

Thanks in advance

--
Meme

Hi!

Try this:

A1 = 10/11/2005

=TEXT(A1,"dddd")

This returns a TEXT value = Tuesday

OR, you could just format the cell, A1, as dddd. This retains it's numeric
value but will display as Tuesday.

Biff

"Meme" wrote in message
...
Hi,

I need to transform a date to week date , for example:
10/11/05 to Tuesday
Is there any formula can do this transform?

Thanks in advance

--
Meme

jsut format the cell with the date as:

dddd

"Meme" wrote:

Hi,

I need to transform a date to week date , for example:
10/11/05 to Tuesday
Is there any formula can do this transform?

Thanks in advance

--
Meme

Hi,
If your date is in A1 then:
=WEEKDAY(A1)
you will need to format the cell to show only the day.....in cell
format select custom and type dddd

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=475201