Show the Current Date Every Day in Excel (or Time)
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.
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: This free Excel macro formats a selection of cells in the Long Date number format in Excel...
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...
Tutorial: How to get the current date using Excel. This method updates the date every day so that ...
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Tutorial: Here, youll learn how to get the difference between two times in Excel. A common example...
Macro: This free Excel macro formats selected cells in the Number or Numerical number format in E...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)