Prior Month Formula

**freybe06** · 02-15-2011, 04:48 PM

Is it possible to make so that if Cell A2 shows the current month then A1 shows the prior month?

In my workbook I have a dropdown menu for month. When a month is picked then a cell in another worksheet changes to that month. What is would like is for the cell next to that cell to change to the prior month.

Ex. I pick January from the dropdown. Then the cell in another worksheet changes to January. The cell next to that should then change to December.

Thanks!

**scottylad2** · 02-15-2011, 04:51 PM

in A1

EOMONTH(B1,-1) Format as mmm

**daddylonglegs** · 02-15-2011, 04:57 PM

If you have the month as text in A1 e.g. January or July then this formula will give you the prior month as text

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

**freybe06** · 02-15-2011, 04:57 PM

I keep getting a #VALUE! error.

**freybe06** · 02-15-2011, 04:59 PM

daddylonglegs - that did it! Thanks to both of you for helping out!

**scottylad2** · 02-15-2011, 07:50 PM

Originally Posted by freybe06

I keep getting a #VALUE! error.

Eomonth is part of the annalysis toolpack, if you've not already installed it then go into options, addins and make sure it's ticked.

I assumed you'd have a date in B1 and if you did this should always show you the previous month. The actual date will be the last day of the previous month, formatted to mmm to reveal the shortened month name only jan feb etc,,