VBA to update the date in my timesheet

[joeyheaf]

I have a worksheet that I am just toying with for my timesheet. I have a little macro where I press ctrl+n to create a new timesheet for a new pay period within the workbook. I am wanting it to update the new worksheet with the correct date (+1 day from the last day on the previous sheet) everytime I make a new worksheet. Also, If it could name the worksheet with those dates similarly to how I have the sheet named in the attached document. (not sure if this last part can be done).