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

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.

I hope you enjoy this Excel Quickie!

#excel #tutorial #excelquickie

[toxiqrox]

Short and sweet just how I like them. Thank you

[jerrydellasala]

I've used Merge Cells for decades, however at least half the time they create a problem at some point down the road. I recently discovered CENTER ACROSS SELECTION - select the cell with the data and adjacent cells, then right click the selection and FORMAT CELLS, and in the ALIGNMENT tab under HORIZONTAL select CENTER ACROSS SELECTION from the drop down. The result is the same as Merge & Center, but the cells aren't merged. As I said, I've been using Excel for decades and only found this recently, I'm using Office 365 Insider Edition and don't know if it's available in earlier versions. Hope that helps.

[wayneedmondson]

Great tip.. however, I avoid merging cells whenever possible due to problems they can cause with ranges and other issues. My fix here is the following: =TEXT(TODAY(), "dddd, mmmm d, yyyy") and =TEXT(NOW(), "mm/d/yyyy hh:ss AM/PM") which will convert the dynamic date and date/time function values to text in the format desired. It can then spill to adjacent cells to the right without the need of merging or setting a very wide column width. It is still dynamic and will change with every re-calc cycle. Might be overkill for some. I just don't want merged cells in worksheets. Works for me. Hope someone finds it useful. Thanks for your great videos. Always learn something new. Thumbs up!!
PS - Agree with Nico's comment below, but I assume this format is for printing a daily report. So, it could be assumed that the current date is always the relevant date when printing the report.

[aliyasseen]

What version of Microsoft office are you using?

[crackedcandy]

it gives me #NAME? there. why? nver had that problem. how do I fix it?

[michaelloy]

My excel document always write past day, I don't know what happened

[krtarmorgansingh]

you did not say to put the prentice clearly so i did not get it, another video was clear so got it from there