Pl post some data. Your description is some what not helping to help you.
Thanks, this function works!
What if I need lastmonthrecords for 12/3117 but I do not want to show 11/30/2017 column?
Hi kevin smith
Easiest method is to just create an INDEX() calculated field. You can place under Date while building the sheet:
This essentially counts number of columns you're showing. Then just right click on the 1 and select "Hide":
Now whenever you change the dates you're trying to display, always bring in one month prior and it'll be hidden.