Excel macro run when save file

hello,


I need one vba code, that will do this:


I open today the file, change what I need and when I press to save the file, it should write the date in the sheet.

Tomorrow when I open the same file, macro should make a new copy with the date from today, the sheet from yesterday should stay after the new sheet.


The macro should do this from monday - friday. Monday is the start of the week.


on monday next week, macro should make the copy in one folder, named calendar week, and the date from monday - and date from friday, then macro should delete in my original file workdays 1-4, and from the friday make the new copy, with the new date (monday in this case), and delete friday.


and I shoul do this every day, and week.


I am not so familiar with dates, I do not know how to write this.


If it is not so complicated, I would appreciate if someone could help me.