Get previous month value based on month value in a cell in excel-CodePudding

Home > OS > Get previous month value based on month value in a cell in excel

Get previous month value based on month value in a cell in excel

Time：11-01

How do I get previous month in abbreviated form based on text value in another cell

Suppose: 
A1 = Nov

I need: 
B1 = Oct

CodePudding user response：

B1 =TEXT(EDATE(--(A1&1),-1),"mmm")