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
|