The enhance the appearance of your worksheet in Excel 2007 includes how to add watermarks, recent dates automatically, hiding the grid lines and adding images to the header section. To add a current date to the header or footer section of the Excel worksheet you first have to change views to the header and footer view: on the Ribbon click on the Design Tab, to the Navigation group and click on the Go to Footer button. There on the contextual related tab, in the Header & Footer Elements group click on the Current Date button. Remember though that once in the Header and Footer view, to go back to Normal view, on the Ribbon click on the View tab and click Normal.

Purchase the training video and you can see this in action for yourself!