Cell to show the last 2nd Month

D

dolphinv4

Hi,

I'd like to show a cell where it shows the last 2nd month
of another cell, ie, in Cell A, the date is 03 May 2004
and I'd like Cell B to show March. I know the format will
be MMMM but how to I get it to show March instead of May.
How do I do it?

Regards,
Val
 
R

RagDyer

Try this:

=DATE(1,MONTH(A1)-2,1)

With formula cell formatted as you said, "mmmm".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi,

I'd like to show a cell where it shows the last 2nd month
of another cell, ie, in Cell A, the date is 03 May 2004
and I'd like Cell B to show March. I know the format will
be MMMM but how to I get it to show March instead of May.
How do I do it?

Regards,
Val
 
Top