Excel Date Help

[Contreras]

= EOMONTH(A2,0) + 1

That should do it.

[SimonMac]

That works, unless the previous month has more days than the current one, in which case you really need the day to always be e.g. 1.

The date is always the first of the month, I tried the custom MMM/YY, and although this changed the visable contents of the cell to Jul/16, it still calculated it as 01/07/2016

[WTFH]

Excel Date Help

That works, unless the previous month has more days than the current one, in which case you really need the day to always be e.g. 1.

[SimonMac]

Scrap that

this works

=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))

[jamesbrown]

Not entirely sure I follow, but if you only want months, why not start in the middle of the month and increment by 365/12?

[WTFH]

Excel Date Help

Change the format of the column to custom and set it to mm/yyyy. That will sort out the date bit, then just add a month on.

[SimonMac]

I have a series of rows, first column should be Month/Year, however it always translates to day/month/year in any calculations.

I would like the date to be calculates based on one month after the cell above, I could use

today()+31

but obviously that wont work on every month, is there a simple way around this?