Working with dates
 

Hi
In cell A1 I have the numeric value of a month for example 3. In A2 I would
like the previous month formatted as MMM. What formula would I use?
Thanks

Working with dates
 

=TEXT(DATE(YEAR(TODAY()),A1-1,1),"mmm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Al" wrote in message
...
Hi
In cell A1 I have the numeric value of a month for example 3. In A2 I
would
like the previous month formatted as MMM. What formula would I use?
Thanks

Working with dates
 

One way: =TEXT(DATE(1,A1,1),"MMM")

another one:
=CHOOSE(A1,"JAN","FEB","MAR","APR","MAY","JUN","JU L","AUG","SEP","OCT","NOV"
,"DEC")


HTH
--
AP

"Al" a écrit dans le message de
...
Hi
In cell A1 I have the numeric value of a month for example 3. In A2 I
would
like the previous month formatted as MMM. What formula would I use?
Thanks

Working with dates
 

Thanks!!!


"Bob Phillips" wrote:

=TEXT(DATE(YEAR(TODAY()),A1-1,1),"mmm")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Al" wrote in message
...
Hi
In cell A1 I have the numeric value of a month for example 3. In A2 I
would
like the previous month formatted as MMM. What formula would I use?
Thanks