Month by Number

default_name

Board Regular
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:
A
B
1
10
<--using "=MONTH(TODAY())"
2
Oct
<--using "=TEXT(A1*28,"mmm")"
3
4
Jul
<--this is what I'd like this cell to say

<tbody>
</tbody>

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
 

Some videos you may like

This Week's Hot Topics

Top