Excel Tips 21 - Automatically Display the Current Date in Excel

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to Automatically display the current date every day in Excel. This tutorial shows you a useful formula which will update the spreadsheet every day to show the current day of the week, day, month, and year. You will also learn how to format dates in Excel so that you can display the date exactly how you want to, in any format.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• dates in excel
• format dates
• display current date in excel
• todays date in excel
• today() function
• function to get date in excel

[Ktumba321]

Hi what about using ctrl semi-colon  or ctrl+shift semi-colon.

[ExcelisHell]

@Ktumba321 That's a very good shortcut! Thanks for sharing it.

[90kapo]

How can I enter only the year? I tried =YEAR(TODAY()) and it gave me 03 July, 1905!!



[sujit58]

Thank you- this is very helpful