VBA Backup Sheet \ Delete Sheet

[t0ny84]

Hi,

I am being lazy with this but hoping someone might already have this built before I commence mashing something together.

IDEA 1
Macro to check if sheet with sheet name Backup + Date exists with a date within 7 days of the Date in the sheet name.
If within 7 days macro would do nothing.
If 7 days or more from this date macro would copy Sheet1 and to the end of the workbook, rename it Backup + Date then hide it.

IDEA 2
On workbook open, macro checks sheet names and if any of the Backup + Date sheets include a date over 6 months in the past the macro would then delete these sheets.

Hoping someone has something already which I might be able to clone \ massacre into doing above

Thanks in Advance.

t0ny84