Previous month, based on user defining current month

[samidodger]

To get straight to the point, a user enters a month either January, February and so on. The formula needs to calculate the previous month.

Thus if the user enters "March", the formula will return February.

all the user will enter is a month not a date.

Thanks,

I know this is simple but I was struggling to find a formula that gives the serial number instead of translating from a serial number.

Thanks

amish

 

[Jonmo1]

Try

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

A1 = March

 

[samidodger]

Quality man.

 

[Ali Kırksekiz]

Sheet1​

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>E2</TH><TD style="TEXT-ALIGN: left">=EOMONTH((1&A1)-1,0)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Cell format: mmmm