While I agree this would be an amazing report to have.. I don't think it's currently possible... We don't have a "date" dimension that could be taken into consideration with the current date...
Now, if you were to potentially use something like Report Builder, you could set up a dimension to store the publish date of the content (in a standard date format), then in Excel when the data is brought in, cast that text field to date and use that to programmatically build out a report based on "today's date"....
It would require some programming and testing to ensure it's working as intended.. but if you can get it working you wouldn't have to do the work manually any longer...
Good luck