Formula Help!

[Guest]

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

 

[Biff]

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

 

[Guest]

jsut format the cell with the date as:

dddd

 

[pinmaster]

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