Formula issue

Susan van Niekerk

Hi Braine Trust

I need some help with a formula

I have Mobilization Date and need to create reports that will show me a list of people who have mobilized -

Any one Mobing Week Prior to the Mob Date

Any one Mobing The Week of the Mob Date

A 2 week Forecast ( so two weeks prior to the Mob Date

A 3 week forecast (so three weeks prior to Mob Date)

Ideally thee would create a dropdown by I dont think that is doable

I just need some sort of filtering to enable me to build 4 report pulling the info - and we cant use today's date as it all needs to be measured of the Mobs date which will be fairly static