Print the Current Date or Time in Excel

Add to Favorites

How to print the current date and or time on an Excel spreadsheet.

This is a simple technique that allows you to display the date and or time in the footer or header of the spreadsheet without it being visible when working in Excel.

Steps to Print the Date/Time in Excel

  1. Go to the View tab and click the Page Layout button.
  2. Now, you will see the spreadsheet divided into pages, which is how it will look when it is printed.  Click the top of the page to add a header, where is says "Click to add header", or the bottom to add a footer, where it says "Click to add footer".

    I will add the date/time in the footer.  When you do this, you can click the middle, left, or right side, depending on where you want the data to appear in the footer.

  3. Once you click in the footer, a new tab called Design should have opened up with options for what you can put into the footer and header.  Let's click Current Date and then hit the space bar to put a space before the time and then click Current Time.

  4. If we now go to Print Preview, we can see the date and time at the bottom of our page.


This is a very simple feature yet it can be very helpful.  Often, this can eliminate the need for displaying a date/time inside the worksheet, which, in order to make current, takes a little programming

Make sure to download the sample workbook so you can see this example in action.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Show the Current Date Every Day in Excel (or Time)
Tutorial: Simple and clean way to show the current date in the worksheet every day in Excel - this ...
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Format Cells in The Long Date Number Format in Excel
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
NOW() - Display The Current Time in Excel
Tutorial: This Excel tip will show you how to display the current time within any Excel spreadsheet....