Excel Date Help

[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?

[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.

[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?

[SimonMac]

Scrap that

this works

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

[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]

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

[Contreras]

= EOMONTH(A2,0) + 1

That should do it.