Show the Current Date Every Day in Excel (or Time)

Add to Favorites
Author: | Edits: don

Simple and clean way to show the current date in the worksheet every day in Excel - this is a quick little Excel tutorial that will help make more presentable spreadsheets.

In this tutorial I combine a few simple techniques to make a nice and presentable date that will update every day and I show you how to do this using a function and then how to control the formatting to display the date however you want it to be displayed.

I also include a few formatting tricks not related to the date so that it will look better within the spreadsheet.


Excel Function: NOW(), TODAY()
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
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...
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...
Get the Current Date in Excel
Tutorial: How to get the current date using Excel.  This method updates the date every day so that ...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Calculate the Difference Between Two Times in Excel
Tutorial: Here, youll learn how to get the difference between two times in Excel. A common example...
Format Cells in The Number (Numerical) Number Format in Excel
Macro: This free Excel macro formats selected cells in the Number or Numerical number format in E...
Tutorial Details
Excel Function: NOW(), TODAY()
Downloadable Files: Excel File
Similar Content
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...
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...
Get the Current Date in Excel
Tutorial: How to get the current date using Excel.  This method updates the date every day so that ...
Excel Forum