CODEWITHSUNDEEP
excelmonthcalendar
mark_crown
mark_crown

Reputation: 135

Excel get the next month from the selected month in a list?

I have a dropdown box with the following listed values:

January 
February
March
April
May
June
July
August
September
October 
November
December

Let's say a user selects 'January from my list:

I have a cell, let's call it Cell B1 and in it i have this formula

=A1

This produces 'January' in cell B1.

However in cell C1, i need to be able to +1 to which ever month is shown in Cell B1.

So if A1 = January, then B1 also = January. But C1 needs to equal February for example.

I have tried simply doing this formula in C1:

=B1 + 1

But because i need my month to be in text rather than number, this won't work and shows #Value error.

Please can someone show me how to overcome this?

Upvotes: 0

Views: 344

Answers (2)

dudu721
dudu721

Reputation: 340

Select Cell B1. In cell format, select custom format and type : mmmm

then just drag the corner of this cell (like you would do to extend a formula) over cell C1 and it will display the next month.

Upvotes: 0

AranDG
AranDG

Reputation: 406

You could use:

=TEXT(DATE(YEAR(NOW()),MONTH(DATEVALUE("01-"&A1&"-"&YEAR(NOW())))+1,1),"mmmm")

Upvotes: 1

Related Questions