How to Insert Date in Footer in Excel (3 Ways)

Footer is often used in our professional life. Some people use their organization’s name as a signature mark while some use their own name. Sometimes it is required to insert the date in the footer. Because it can help us to define the editing or printing time of that data and keep the spreadsheet intact. In this article, we will demonstrate to you, how to insert a date in the footer in Excel.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Easy Methods to Insert Date in Footer in Excel

For describing the methods, we are considering a datasheet of 34 city dwellers’ information. Their dome type, location, number of family members, and their income and expenditure details in the range of cells B4:I38. We will show 3 distinct processes to insert the footer at the bottom of the page.


1. Using Insert Tab in Excel

In this process, we will insert the date in the footer of our spreadsheet using the ribbon options of Excel. The steps of this process are given as follows:

📌 Steps:

  • First of all, select the Insert tab from the Toolbar.
  • Go to the Text group.
  • Click on the Header & Footer.

Insert Footer from Insert Tab

  • The cursor will be in the center header by default. Now, click on any empty white area on the Excel sheet.

  • Scroll down by your mouse and you will see the Add Footer option.

Insert Footer from Insert Tab

  • There will be three separate alignments. Left, Center, and Right. We choose the left alignment to insert the date.
  • After that, in the Header & Footer tab, select Current Date. Or your can write down the following formula.
&[Date]

Insert Footer from Insert Tab

  • Click on any empty white area to insert the date.
  • You will find the date will be placed at our desired place.

Insert Footer from Insert Tab

So, we can say that our method worked perfectly.

Read More: Add The Footer Page 1 To The Current Worksheet


Similar Readings


2. Page Setup Option to Insert Date in Footer

In this method, we are going to insert the date in the footer using the Page Setup option. It is an amazing feature, to insert the footer on every printed page of your datasheet. The procedure is explained below step by step:

📌 Steps:

  • First, in the Page Layout tab, select Page Setup Dialog Box Launcher.

Using Page Setup Option

  • You can also get the Page Setup option from the Print feature. For that, press ‘Ctrl+P’ on your keyboard.

Using Page Setup Option

  • Now, in the Page Setup dialog box, select Header/Footer > Custom Footer.

Using Page Setup Option

  • A new dialog box entitled Footer will appear.
  • In this dialog box, you will see 3 different sections to insert the footer. Choose anyone. In our case, we choose the Left Section.

  • Above the footer alignment section, you will see some other option icons. Now, move your mouse cursor slowly on these icons and it will show you their feature like the image.

  • Then, click the Insert Date or you can simply write the following formula into your desired section.
&[Date]
  • Click OK to close the Footer dialog box.

Using Page Setup Option

  • You will see a preview of your footer in the Footer section of the Page Setup dialog box.
  • Again, click OK if you are satisfied with your footer.

Using Page Setup Option

  • After that, in the View tab, select the Page Layout option.

  • You will see the footer in the bottom left corner of that page.

Using Page Setup Option

Thus, we can say that our process worked effectively.

Read More: How to Insert Day and Date in Excel (3 Ways)


3. Embedding VBA Code to Insert Footer

Writing a VBA code can also help you to insert the date in the footer. For showing this method, we are using the same datasheet which we have already used. Our dataset is in the range of cells B4:I38. The steps of this process are given as follows:

📌 Steps:

  • To start the approach, go to the Developer tab and click on Visual Basic. If you don’t have that, you have to enable the Developer tab. Or You can also press ‘Alt+F11’ for opening the Visual Basic Editor.

Embedding VBA Code to Insert Footer

  • A dialog box will appear.
  • Now, in the Insert tab on that box, click Module.

Embedding VBA Code to Insert Footer

  • Then, write down the following visual code in that empty editor box.

Sub Insert_Date_in_Footer()
Dim Footer As String
On Error Resume Next
Footer = ActiveWorkbook.BuiltinDocumentProperties("Last Saved date")
If Err = 440 Then
   Err = 0
   Footer = ActiveWorkbook.BuiltinDocumentProperties("Date of Creation")
   If Err = 440 Then
      Err = 0
      Footer = "Not Set"
   End If
End If
Footer = Left(Footer, 8)
ActiveSheet.PageSetup.LeftFooter = Footer
End Sub
  • Close the Editor Now, from the View ribbon, click on Macros > View Macros.

  • A new dialog box called Macro will appear. Select Insert_Date_in_Footer.
  • Click on the Run button to run this code.

Embedding VBA Code to Insert Footer

  • Then, from the View tab, select the Page Layout option.

Embedding VBA Code to Insert Footer

  • At last, you will see the footer at the bottom of that page.

Embedding VBA Code to Insert Footer

Finally, we can say that our visual code worked successfully and we are able to insert the date in the footer section.

Read More: How to Insert a Footer in Excel (2 Suitable Ways)


Conclusion

That’s the end of our today’s article. I hope that this will be helpful for you and you will be able to insert the date in the footer in Excel. If you have any further queries or recommendations, please share them with us in the comments section below.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo