How to Set the Date on Excel to Be Updated Automatically

by Carter McBride
In Excel, you can set the date to be updated automatically on a spreadsheet.

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.

1

Click on the cell you want the date to appear.

2

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

3

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

References

About the Author

Carter McBride started writing in 2007 with CMBA's IP section. He has written for Bureau of National Affairs, Inc and various websites. He received a CALI Award for The Actual Impact of MasterCard's Initial Public Offering in 2008. McBride is an attorney with a Juris Doctor from Case Western Reserve University and a Master of Science in accounting from the University of Connecticut.

Photo Credits

  • photo_camera Jupiterimages/Brand X Pictures/Getty Images