Current Month minus 2 months

[willow1985]

Hello,

I know the formula to find the previous month name: =TEXT(TODAY()-DAY(TODAY()),"mmmm")

But how could you modify this to give you minus 2 months or 3 months?

I am looking to reference another column to maybe minus number sequences from 0 - 6 subtracting a month at a time but I need it to return the month name.

Do my list would be current month
previous month
3 months back etc

October
September
August

Thank you to anyone who can help

Carla

 

[Luthius]

=TEXT(EDATE(TODAY(),-2),"mmmm")

 

[Fluff]

How about

Book1
	A	B
2	0	October
3	1	September
4	2	August
5	3	July
6	4	June
7	5	May
8	6	April
Master

Cell Formulas
Range	Formula
B2	=TEXT(EDATE(TODAY(),-A2),"mmmm")

 

[willow1985]

That is perfect! Thank you both very much!

 

[Fluff]

Glad we could help & thanks for the feedback