Thread: Function to give previous month
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay
 
Posts: n/a
Default Function to give previous month

On 25/6/06 15:04, in article
, "daddylonglegs"
wrote:


Hi Jay,

Use this formula

=TEXT(("1 "&A1)-1,"mmmm")

where A1 contains the Month in text, i.e. "August" or "Aug"


Daddylonglegs,

Well that's certainly a *lot* less work than mine:-) Can you just parse it
for me (if you don't mind) I'm familiar with the text Ÿn and the -1 must be
giving the previous month, but what does the "1 "& do?

Many thanks

-Jay-

Reply With QuoteReply With Quote