How to Set the Date on Excel to Be Updated Automatically

by ContributorUpdated April 02, 2020
Morsa Images/DigitalVision/GettyImages

Microsoft Excel has a function that updates the date automatically whenever the spreadsheet is opened. So every time you access the spreadsheet, you can just print out the sheet and it will have the current date on it. This feature allows you to keep track of different modifications of the spreadsheet in paper form without having to remember to note down or change the date yourself.

Click on the cell you want the date to appear.

Screenshot of selecting cell in Excel.

Type "=TODAY()" if you just want the date. Type "=NOW()" if you want the date and time.

Screenshot of current date formula in Excel.

Press "Enter" on your keyboard. The day will automatically appear and update.

Screenshot of current date in Excel displayed in cell.


About the Author

This article was written by a professional writer, copy edited and fact checked through a multi-point auditing system, in efforts to ensure our readers only receive the best information. To submit your questions or ideas, or to simply learn more, see our about us page: link below.

More Articles