I need to create a header that includes a date that will update each time a
pivot table is opened--which I know how to do-- but how do I also include a
"last date refreshed"

In other words, when I first open this pivot table, I want to see
yesterday's date (last date opened) and today's date. Of course, sometimes I
will be opening it on Monday, and the last date opened will be the previous
Friday. Any help??

Thanks,