View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Al
 
Posts: n/a
Default 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