I have a worksheet and I want the date in Cell A5 to show current date if the
pivot table on the worksheet refreshes. Can someone provide the code?

I have another worksheet and I only want date in Cell E2 to update if any
edits were made in worksheet. Can someone give me code for this?

Thanks,

Aidan.