Did you know that you can add the current date in header in Excel? You can add this via Excel Macros in a single click!
Make sure your Excel has the Developer Tab enabled following this tutorial.
I explain how you can do this below step by step!
What does it do?
Add the current date to the header
Copy Source Code:
Sub AddDateInHeader() 'For this example, we are using the center header to show the date With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "&D" .RightHeader = "" End With ActiveWindow.View = xlNormalView End Sub
STEP 1: Go to Developer > Code > Visual Basic
STEP 2: Paste in your code and Select Save. Close the window afterwards.
STEP 3: Let us test it out!
Go to Developer > Code > Macros
Make sure your macro is selected. Click Run.
To check if the header did get added, go to File > Print:
Now you should be able to see the current date on your header!
How to Add Date In Header Using Macros In Excel