Need Code for Previous Month

  • Thread starter Thread starter M Harrison
  • Start date Start date
M

M Harrison

How do I set PreviousMonth to a 3 char Month? For example: If the current
month is March, I'd like to return the characters Feb for the previous
month of February.

Thanks,
Mike
 
Subtract one month from the date, and format as mmm:
=Format(DateAdd("m", -1, Date()), "mmm")
 
Back
Top