I want to filter out dates that aren't within the previous month

Help
, , ,
1

I am working on a robot which will have dynamic data coming in and I need to filter out anything that was not raised (in ‘Opened’ column on example) in the last month.
So if I ran it in December, it would pull out anything from November and remove the rest.
If I ran it in January, it would pull out December and so on.

I am having trouble working out how best to do this.
Can anyone help?

Test.xlsx (27.2 KB)

2

@thetruestorey

Check these out… Assign the date to variable and subtract 1 month from the date?