Tips.Net > ExcelTips Home > Formulas > Date Formulas > Inserting Tomorrow's Date
Inserting Tomorrow's Date
Summary: If you need to add tomorrow’s date to a worksheet, you can do it using simple math. The formulas provided in this tip are both illuminating and helpful. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
You may want to insert tomorrow's date into a cell in your worksheet. This is easily done by simply creating a formula that includes the function for today's date, as in the following:
=TODAY() + 1
This formula first determines today's date, and then adds 1 to it, resulting in tomorrow's date. You can then use Excel's formatting features to display the resulting date in any manner desired.
Besides displaying tomorrow's date, you can modify the formula to display a date at any time in the future. Simply change the formula so the desired number of days are being added to today's date. For instance, if you wanted to determine a date two weeks in the future, you could use the following:
=TODAY() + 14
Tip #2529 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
Check out ExcelTips Premium today!
Macros Rock!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site