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.
1 Like
=DATE(YEAR(A1);MONTH(A1)+1;DAY(A1))
2 Likes
This solution looks a little bit odd. Say, A1=2020-10-31, it returns 2020-12-01.
I think the question’s expected solution is: =EOMONTH(A1,1)
This solution matched the question as asked: if you read it, it explicitly mentions that days in the bills are always 01.
If you need an arbitrary date incremented by a month, you need to use EDATE (which is of course a better solution).
EOMONTH will not do what is asked - e.g., for 2020-10-01 it will not give 2020-11-01, but 2020-11-30.
1 Like
I apologize for my comment above; I overlooked Hesch’s question. The arbituary-day addMonth() function was actually the question I myself was looking for; I actually imposed mine on Hesch’s. Sorry about that!
For my EOMONTH(a1,1) solution, I now think the results are wired. The resulting days become the ends of the months, mostly more than 30 days from the arbituary input day (a1). Say A1=2020-10-01, eomonth(A1,1) returns 2020-11-30, almost two months are added… Well, my question is bad and slack indeed.