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.
A+mroo


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.
A+mroo

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

How about:

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,1),"mmmm")

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.
A+mroo