MrExcel Publishing
Your One Stop for Excel Tips & Solutions

passed month

Posted by amroo on May 22, 2001 6:47 AM

Bonsoir,because the data that were used under my macro concern the passed month I want the name of the passed month (expl : April because we are in May) appears in range("A1") when I run my macro (I use 2 repetitions in this sentence for being clear ).
2001 thanks for helpers.

Posted by Eusebio on May 22, 2001 7:07 AM

Perhaps :-
=EDATE(TODAY(),-1) and extract month ???

Posted by amroo on May 22, 2001 7:25 AM

Thanks Eusebio (as the great football player)
but I have this formula:=Month(Now())-1 which gave me the number of the passed month not in letter.
Try again.

Posted by cpod on May 22, 2001 8:07 AM

How about:


Posted by Barrie Davidson on May 22, 2001 8:32 AM

See cpod's answer for your formatting

Posted by amroo on May 23, 2001 2:48 AM

Thank to whom it may concern

THANKS for all whom give time to help us.