Forum Discussion
Filter dates previous Wednesday to Tuesday (Power Query or formula)
EDIT: Have updated this as I've worked out some issues but discovered more.... I am trying to use Power Query to combine some monthly data into weekly chunks provided by 5 different offices. ...
davidmaddock54 The workbook you attached contains a sheet for January with nothing in it and one for February with some data in it. You mention that you were "able to get PQ to sort down to the current Month worksheet", but you don't include the query(s) nor the results of it. And you don't show what the expected outcome should be if it's around the end of the month.
Please upload a file that give a more complete picture of what you are dealing with.
Oops. Something didn't save. Thanks Riny. Will have a look and update.