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