I assume you meant DAY and not MONTH.
If A1 holds the first date . in B1 type: =Day(A1) and format, column "B", as
dddd.
Pls nothoce that you can also Custom Format the dates in col. "A" in order
to avoid the helper column [b].
Micky


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