Good point... and easily solved...
=TEXT(DATE(1,MONTH(A4),0),"mmmm")
but, I like formula better (it's cleaner).
Rick
"T. Valko" wrote in message
...
That won't work for any date in January.
Try this:
=TEXT(D2-DAY(D2),"mmmm")
--
Biff
Microsoft Excel MVP
"Rick Rothstein (MVP - VB)" wrote in
message ...
Actually, I'm pretty sure this simpler formula will always work...
=TEXT(DATE(0,MONTH(D2),0),"mmmm")
Rick
"Rick Rothstein (MVP - VB)" wrote
in message ...
Here is one way...
=TEXT(DATE(YEAR(D2),MONTH(D2)-1,1),"mmmm")
Rick
"Esradekan" wrote in message
...
On Jun 30, 3:36 pm, Esradekan wrote:
I have a date in cell D2 (DD-MM-YYYY), I wish in cell D3, to put the
month only prior to that date. That date will change from time to
time.
Any help?
TIA
Esra
in other words, I should have said, if the date in D2 is 30th June, I
wish May to be teh result of the formula in D3