Excel formula

zetor 4911

Hi,
Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance

kevincaomhin

zetor 4911 wrote: »

Hi,
Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance

The following could work for limited number of rows;

If you enter a date in cell A1 - 11/12/2020
Change format of cell to custom "mmmm"
it should show December
Go to cell A2 and enter formula =A1 +15
That should show January
etc etc.

phonypony

I would use edate- Use the cell formatting as Kevin says, then in A2: =edate(A1, 1)

zetor 4911

zetor 4911 wrote: »

Hi,
Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance

In A1 type March, in B1 type April. then highlight both cells and drag the fill button at the bottom right hand corner of the selected cell to the right and it will automatically fill in the months.

Jimbob1977

Automatically (no need for formulae):

1. Write "Mar" or "Mar-2020" in Cell A1

2. Drag Cell A1's bottom-right hand corner by the cursor


It will populate the coming months indefinitely.

It can be dragged left-to right or up-to-down

To your heart's content.

Seth Brundle

If the word "March" is in cell A1 then use the following formula...

=TEXT(EDATE(DATEVALUE("01-" & A1 & "-2020"),1),"mmmm")

DATEVALUE("01-" & A1 & "-2020") allows me to convert the word to an actual date.
EDATE allows me to add one month to our date
TEXT allows me to format our new date in mmmm (full month name) format

zetor 4911

kevincaomhin wrote: »

The following could work for limited number of rows;

If you enter a date in cell A1 - 11/12/2020
Change format of cell to custom "mmmm"
it should show December
Go to cell A2 and enter formula =A1 +15
That should show January
etc etc.

Thanks for that. I prefer to not enter the date in cell A1 just want to enter the month (March) is this possible?

zetor 4911

Seth Brundle wrote: »

If the word "March" is in cell A1 then use the following formula...

=TEXT(EDATE(DATEVALUE("01-" & A1 & "-2020"),1),"mmmm")

DATEVALUE("01-" & A1 & "-2020") allows me to convert the word to an actual date.
EDATE allows me to add one month to our date
TEXT allows me to format our new date in mmmm (full month name) format

That worked for me many thanks to all for the suggestions.