By way of proof try this...

=TEXT(MONTH(A1),"mm dd yyyy dddd")
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

Not to burst your bubble but that formula will return a very wrong result.
The Month formula will return a number from 1 to 12 representing the months
of the year. Since XL stores dates as the number of days since Jan 1 1900
what you actually have is Jan 1 through Jan 12 1900. You will get back the
days of the week for those dates. The final problem is that XL has the wrong
days of the week for those dates as an intentional bug.

http://spreadsheetpage.com/index.php...onal_date_bug/

The question in itself does not make sense. If you only get the month for
the date then the day of the week is lost at that point.
--
HTH...

Jim Thomlinson


"Eduardo" wrote:

Hi,
use

=TEXT(MONTH(A1),"dddd")

"Emece" wrote:

I have a column with dates in the following format: 30/03/2010 (Spanish date
format) I want to display in another column only the month, and in format
dddd, so that it shows Tuesday.

I do this in to steps:
1. =month(date)
2. Change the format to a custom one: dddd

Is there a way to do this in only one step?

Thanks in advance

Regards,
Emece.-