Add Date In Header Using Macros In Excel

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

Final Result: 

Exercise Workbook:

---

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