Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Calculating a Future Date.

Calculating a Future Date

by Allen Wyatt
(last updated March 30, 2013)

If you are creating a macro to do some processing on a document, you may have a need to calculate a date at some point in the future. Using the VBA DateAdd function, this is quite easy. The function has the following syntax:

DateAdd(interval, number, startdate)

The original date that you begin with (typically today's date) is specified by the startdate argument. The interval argument indicates what you want to add to the startdate. For instance, if you want to add days, then interval would be the letter d. (This interval needs to be enclosed within quotes.) There are many different intervals you can specify:

Interval Meaning
d Day
ww Week
m Month
q Quarter
yyyy Year
y Day of year
w Weekday
h Hour
n Minute
s Second

Finally, the number argument specifies how many intervals you want to add to the date.

As an example, let's suppose you wanted to know the date that was 90 days in the future. You could use the following:

dFutureDate = DateAdd("d", 90, Date)

When executed, dFutureDate contains the date that is 90 days after today.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1476) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Calculating a Future Date.

Author Bio

Allen Wyatt

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

MORE FROM ALLEN

Resizing Checkboxes

If you create a user form in VBA that includes checkboxes, you may want to make the checkboxes larger. You can't adjust their ...

Discover More

Patterns of Numbers with a Formula

Want to create a sequential pattern using formulas? It's easy to do if you take a look at how your data repeats. This tip ...

Discover More

Messed-up Typing

It is not uncommon for newcomers to Word to overwrite their existing document text as they are editing. There is a reason for ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

MORE WORDTIPS (MENU)

Options in Creating New Files

You'd think that Word would be consistent, right? Wrong! Here's one example where Word is anything but consistent when it ...

Discover More

Occurrences of a Text String within a Document

You may have a need to find out how many times a certain text string occurs within a document. You can find out manually ...

Discover More

Changing What Is Pasted in a Dialog Box

When you record a macro, Word very literally records what you do. This includes filling in various settings in dialog boxes. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share