So I think the question was how to get Diciembre instead of December.

Presumably a matter of setting the Windows Regional Options (in Control
Panel, not in Excel) to Spanish?
--
David Biddulph

"Arvi Laanemets" wrote in message
...
Hi


"mbparks" wrote in message
...
I understand your formula to read as if "DateReference" is the cell
containing the date. Is this correct?

Yes


I am not sure how to indicate "SpanishDateFormat". I put the formula
with
this text in it but got a #VALUE? error.


The format string like the one when you use when formatting the date with
Custom format. P.e.

=TEXT(TODAY(),"dd.mm.yyyy") returns '16.12.2009'


=TEXT(TODAY(),"mmmm") returns 'December'

=TEXT(TODAY(),"mmmm, d. yyyy.") returns 'December, 16. 2009.'
etc.



Arvi Laanemets