Excel Formulas

I'm trying to set up a Diary in Excel where I can create a new sheet each day and the date will automatically convert to be 1 day ahead of the following sheet. the formula works but the date only cha...