Month by Number

[default_name]

Hello,

I am wondering if there is a way to calculate months mathematically.
For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this?

Here's what I have:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]10
[/TD]
[TD]<--using "=MONTH(TODAY())"
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Oct
[/TD]
[TD]<--using "=TEXT(A1*28,"mmm")"
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Jul
[/TD]
[TD]<--this is what I'd like this cell to say
[/TD]
[/TR]
</tbody>[/TABLE]

I would like cell A3 to say Jul...but not quite sure how to do that.
I tried "=A1-3" but I suppose it is more complex then that...but I'm trying to get something like this

I am trying to figure out a way to do it without the use of VBA.

Thanks in advance

 

[Rick Rothstein]

Try this formula...

=TEXT(28*(A1-3),"mmm")

 

[default_name]

Thanks Rick!!