default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
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:
<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
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