Excel Header Formula

I would like to be able to use a header in excel with the formula "=today()". I know I can add todays date in the header but I was hoping to have it auto calculate every day I open the sheet to read ...