I am looking for a formula that will return data from the previous month. I know I could use a simple filter tool and define my dates each month, but I would like to automate the process so it's always looking back at the previous months data.
Example: Today is 6/6/2018, I would like all data from 5/1/2018-5/31/2018
In 2 months (8/6/2018), I would like data from 7/1/2018-7/31/2018