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.

Question? Ask it in our Excel Forum


Excel Function: NOW(), TODAY()
Downloadable Files: Excel File

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...