Current Stage Duration

Hi,

1) I need a report that shows how long deals have been sitting in their current stage. So if a deal was moved into the current stage 5 days ago, I want it to show stage duration of 5 days. The stage duration is currently blank for current stages - is there any way to populate this or create a custom report using the difference between the modified time and today's date?

2.) I need to know how many deals moved from one stage to the next stage over the last 7 days. The goal is to aggregate these counts and determine how many deals moved across multiple stages in the last 7 days. I can see sales duration, but these deals are still in progress. I just need to identify bottlenecks in the pipeline.

Can someone help me?

Thank you