I'm looking for a more efficient way to show the subsequent month in a series. The month format I have to use is YYYYMM, but it has to be in number format. It has to do with the people who are entering the information. Explaining to them to enter a month as 10/2021, for example, is actually confusing to them, so I have them enter it as 202110. I use these numbers to calculate the difference between meter readings during a given period of time.
The best solution I've come up with is a strange combination of SUMIFS, VLOOKUP, and a table of sequential months. I'm pretty sure there's a more efficient way, but just can't figure it out.
Any thoughts?
Thanks.
Bookmarks