1. Get the max of Close date.
2). then calculate the difference between max_Close_date and your actual close dates
Week_diff = DATEDIFF('week',[Close Date],[max close date])
3). Use this as a filter in the work book and select 0 to -7
Hope this helps !!
1 of 1 people found this helpful
should be sufficient
Thank you Norbert. It worked like a charm !!!
You are welcome.
Thanks for the "Badges". Appreciated!:)