Hello guys,
I want to get the month after of a selected month. For example, if the selected month is January I want the result to be February. If February then March and so on.
I have a list of months that a user can select in a particular cell B3, once a month is selected in that cell. The cell in c5 should automatically set to the next month of the selected month.
I found this formula on the net. But it works the other way around, instead of the next month, it gives the previous month. I tried changing the -1 to +1 and see if it works but it doesn't instead it only returns the selected month. Anyone can help me? Thanks a lot in advance.
=TEXT((1&B3)-1,"mmmm")
Bookmarks