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.-