Add one month in Numbers

Well. there is a function called edate() which allows you to offset by some number of months from a starting date. OF course, the starting date must be valid and there are some weird things when the starting date is a day of one month that does not exist in another month.

e.g.

what is 1 month from 29 Jan 2017?

Anyway... you can do this:

A1 contains 1/29/2017

A2=EDATE(A1, 1)

this is shorthand for... select cell S2, then type, or copy and paste from here, then formula:

=EDATE(A1, 1)

To fill down, select cell A2, copy

now select cells A2 thru the end of column A, paste

select cell

There are lots of ways to do this... it depends on your goal:

Hi Bruce,

Correct 'guess' on why there's no '1m' duration value, I think—unlike 1d and 1w, it's not a fixed number of smaller units in size.

From your original post: "It gets weird if the first date is not the 1st of the month."

Actually it doesn't get 'weird' unless the day is after the 28th of the month. For any date up to the 28th, EDATE(date,1) will return the same day of the following month.

What result do you want when you add 'a month' to January 30, 2017?

What result do you want when you add 'a month' to February 28, 2017?

What result do you want when you add 'a month' to Apr 30, 2017?

If you can state the desired results where 'a month' later isn't 'the same date next month,' then it's likely possible to calculate those desired results. An alternative is to avoid dates after the 28th of the month when scheduling anything that is to occur monthly (or bi-monthly).

Regards,

Barry

Hi Wayne,

Just noticed the new dot set on your posts!

Looks good on you! Congratulations!!

Regards,

Barry