How to Automate Dates in MS Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Automate Dates in MS Excel
Use the =TODAY function to help automate dates in Excel. (laptop image by Angie Lingnau from Fotolia.com)

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.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

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

  2. 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.

  3. 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."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.