Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Inserting Tomorrow's Date.
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
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8968) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Inserting Tomorrow's Date.
More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want. Check out ExcelTips: The Macros today!