willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 931
- Office Version
- 365
- Platform
- Windows
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
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