Hi

Format cell D3, FormatCellsNumberCustom mmm
In Cell D3 enter
=D2-DAY(D2)
--
Regards
Roger Govier

"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