I want to make continues month list starting from specific date in English. Lets say my date is `29.4.2019`

. I would like Excel formula to display months in English starting from that date, so my list would look like (by dropping down):

```
May
July
August
September
October
November
December
January
February
etc...
```

I have tried this formula but it ends up on December, also I have to input `+1, +2, +3`

manually:

```
=CHOOSE(MONTH(A1)+1;"January";"February";"March";"April";"May";"July";"August";"September";"October";"November";"December")
```

Also the problem is that I use Finnish Excel so function should be `=TEXT(MONTH(A1);"kkkk")`

instead of `=TEXT(MONTH(A1);"mmmm")`

if I want to use more simple version with `=TEXT`

function. However this will not work once Excel will be opened on English version of Excel as it will not recognize "kkkk" inside the formula and will give an error.

I have VBA to convert to international format but this does not seem to work either (https://superuser.com/questions/730371).

```
Public Function FMT$(ByVal Value, ByVal strFormat)
FMT = VBA.Format$(Value, strFormat)
End Function
```

**EDIT:**

Ok. That was stupid mistake... I skipped "June" in my list. This function seems to be working now:

```
=CHOOSE(MONTH(A1)+1;"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December")
```

I guess you could try the following:

The above formula basically uses two branches of the

`IF`

(you might have to pick a more appropriate condition depending on the layout of your excel sheet and where you need the results to be, but without knowing that, that's the best I can offer).So basically if it's the first one, the cell directly above will be blank, so the formula will be simply

`TEXT($A$1,"kkkk")`

. If there's a value, then we need to add one month, and to do that as accurate as possible, I would use`DATE(YEAR($A$1),1+MONTH("1-"&C1&"-"&YEAR($A$1)),1)`

, which basically takes the year of the date supplied in A1, the month following the previous month, and 1 as the date. Excel can understand the format`d-mmmm-yyyy`

as date, so I'm taking advantage of that.Not using

`TEXT`

: