I have a database that is organized quarterly. I would like to save myself from having to manually move data onto a new sheet after 3 months have passed. I tried using an IF function, but couldn't quite get it to work. What would others suggest?
(Current quarter in 1 sheet, ALL previous quarters on a seperate sheet, ideally to transfer automatically once the 3 months has ended.)
What function do I use to pull data prior to a certain date?