Excel: Update date automatically
You can enter an automatic date in Excel that updates itself automatically. We show you how to do this with this practical tip.
How to get an automatically updated date from Excel
The easiest way is to insert the constantly updated date in the header. We'll show you how it works for Microsoft Excel 2007. This works similarly for other versions of Excel.
- Click on "Insert" in the upper area and then on "Header and Footer".
- Then select the item "Current date". Also compare the screenshot.
- When you're done, just click in the document. The current date from today appears.
- Now close the document so that it can be processed further the next day, the date updates itself. You will always see the current date in this Excel document.
In another article we will show you again in detail how you can use Excel to calculate the age of a person based on a birthday.