Ask Your Question
1

How do I add one month to a date in a worksheet? [closed]

asked 2017-10-05 21:52:50 +0100

Hesch gravatar image

I am creating a list of monthly electric bills; Column 1 has the BillingPeriod date as yyyy-mm-01. I want each succeeding Row to show yyyy-(mm+1)-01.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Hesch
close date 2017-10-05 23:11:35.518788

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-05 21:59:41 +0100

=DATE(YEAR(A1);MONTH(A1)+1;DAY(A1))

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2017-10-05 21:52:50 +0100

Seen: 1,355 times

Last updated: Oct 05 '17