How to Automate Dates in MS Excel

By Carter McBride

Microsoft Excel has an automatic dating system that allows you to add dates to your spreadsheet. These dates can apply the same formula functions that any normal Excel cell can use. In order to use the date function, you need to use =TODAY. This sets the date to the date on the computer. Once you use it, you can add to the date or subtract from the date. This then automatically updates each day.

Step 1

Type "=TODAY()" in the cell you want to automatically update.

Step 2

Add "+" and any number of days you want added to today's date for the spreadsheet to calculate. For example, you have an spreadsheet for invoices due 20 days from today. If you enter "=TODAY()+20" in the invoice due date sheet, any time you open the spreadsheet, the due date automatically updates.

Step 3

Add "-" and any number you want to subtract from today's date for the spreadsheet to calculate. For example, you need a cell to show five days ago from the date you use the spreadsheet. You would type "=TODAY()-5."