Insert Date In Header. Today TEXTTODAYdd-mmm-yy Where Today is the text you want included. Insert datetime header at top of file.
Insert current date and time in headerfooter by Page Setup function 1. Open the report in Design View. In this case how could you change the date or date time format to your own need in header or footer as following screenshot shown.
To print the time in regional format click Time Regional Format.
From the Header Footer Ribbon menu click Insert Date or Insert Time. Click on the cell with the first date to select it and then drag the fill handle across or down the cells where you want Excel to add dates. The Include Date checkbox should be marked to include the date. Select the Insert button at the top navigation.
