rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 569
- Office Version
- 365
- Platform
- Windows
I have in one cell the following formula:
=TEXT(TODAY(),"mmmm")
This will display the current month for today "March". Perfect.
I have the cell merged with the next four cells. The next five blocks of cells are all five columns worth of cells merged together. In the second block, I would like to have the next month displayed. I have the following formula in the next cell.
=TEXT(MONTH(TODAY())+1,"mmmm")
The result I get is "January"
Is there a simple formula that will allow me to get the correct next month displayed? I would then like to add "+2", "+3", etc. to fill the next four cells with successive months.
Thanks for the support.
=TEXT(TODAY(),"mmmm")
This will display the current month for today "March". Perfect.
I have the cell merged with the next four cells. The next five blocks of cells are all five columns worth of cells merged together. In the second block, I would like to have the next month displayed. I have the following formula in the next cell.
=TEXT(MONTH(TODAY())+1,"mmmm")
The result I get is "January"
Is there a simple formula that will allow me to get the correct next month displayed? I would then like to add "+2", "+3", etc. to fill the next four cells with successive months.
Thanks for the support.