Pipeline report that show opportunities as of today

Pipeline report that show opportunities as of today

How do I create a weekly trending stacked pipeline stage report using an "as of" date of the day I run the report?  The x-axis will show the weekly date. But I am not sure how I create a formula for this. The purpose of the report is to show the change in the pipeline from week to week.  Thank you.