Excel Current Month (Sept), Curr Month -1 (Aug), Curr Month -2 (July) Formula

[atlsftp]

What formula can I use to return the current month, current month -1 and current month -2 for a dashboard that will update monthly?

Current month = September
Current month -1 = August
Current month -2 = July

 

[alansidman]

[table="class:thin_grid"]
[tr][td]v[/td]
[td="bgcolor:#ECF0F0, align:center"]A[/td]
[/tr][tr][td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=MONTH(TODAY())[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=MONTH(TODAY())-1[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]=MONTH(TODAY())-2[/td]
[/tr]
[/table]

 

[MARK858]

A slight adaption, A2 copied/dragged down....

Excel Workbook
	A
1	September
2	August
3	July
4	June
5	May
6	April
7	March
8	February
9	January
Sheet1

 

[MARK858]

Or actually just A1 copied/dragged down....

Excel Workbook
	A
1	September
2	August
3	July
4	June
5	May
6	April
7	March
8	February
9	January
10	December
11	November
12	October
13	September
Sheet1

 

[atlsftp]

Is there a way to do this without using today()? I don't want the file to change everytime I open it.

 

[MARK858]

Why would it change each time, it only changes at the change in month (yes it does re-calculate each time but the result doesn't change until the month does)?

 

[jtakw]

Hi,

I think we can also use the EDATE function.

Use formula in A1 copied down, works just like the formula provided by MARK858.

Use formula in C1 copied down, Months only change when you change the date in the reference cell:

Book1
	A	B	C	D
1	September		July	7/4/2018
2	August		June
3	July		May
4	June		April
5	May		March
6	April		February
7	March		January
8	February		December
9	January		November
10	December		October
11	November		September
12	October		August
13	September		July
Sheet227

Cell Formulas
Range	Formula
A1	=TEXT(EDATE(TODAY(),-ROWS(A$1:A1)+1),"mmmm")
C1	=TEXT(EDATE(D$1,-ROWS(C$1:C1)+1),"mmmm")