Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
Tex Dates to numerical Dates | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |