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