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.
Excel File: www.teachexcel...
Excel Quickie 64: • Excel Shortcut - Go To...
Excel Quickie Playlist: • Excel Quickies
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!
TeachExcel.com
#excel #tutorial #excelquickie

[@toxiqrox]

Short and sweet just how I like them. Thank you

[@TeachExcel]

I'm glad you liked it Kathy! You're welcome!

[@sudhirtrivedi3348]

When I like, it become 100 from 99👏

[@lisamccray6481]

Thanks. Quick and enlightening.

[@TeachExcel]

You are very welcome! :)

[@Jong-JongDomo]

Thanks man.

[@wayneedmondson1065]

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.

[@TeachExcel]

That is a great tip for avoiding merged cells here! I did think about that but didn't want to include in the quickie, so your comment compliments it perfectly! I think it will work great for users more comfortable with nested formulas. I probably should have used a different title for the page than "Your Report" lol - probably, "Dashboard" would have been better.

[@jagadeesanjack1569]

You are awesome.... Thanks .. Lot of love

[@jerrydellasala7643]

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.

[@crackedcandy7958]

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

[@michaelloy9013]

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

[@JudyF-xd5yy]

Yes you missed the () at the end of the formula

[@aliyasseen6776]

What version of Microsoft office are you using?

[@TeachExcel]

I think this video uses Excel 365 - though new features have been added to Excel 365 since this video was made and so my interface currently looks a little different.