Can you compute a date in word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

delores - 27 May 2005 21:58 GMT

I am trying to figure out if word can take todays date and then return me a
date that is 30.60 or 90 days in the future?

Reply to this Message

Graham Mayor - 28 May 2005 05:44 GMT

Yes but not easily - see
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am trying to figure out if word can take todays date and then
> return me a date that is 30.60 or 90 days in the future?

Reply to this Message

Doug Robbins - 28 May 2005 08:15 GMT

Running a macro containing the following code will insert a date 30 days in
the future at the location of the cursor.

Selection.InsertBefore DateAdd("d", 30, Date)

You can use the formatting function to get the format that you want. e.g.

Selection.InsertBefore Format(DateAdd("d", 30, Date), "dddd, MMMM d, yyyy")

will insert

Monday, June 27, 2005

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to figure out if word can take todays date and then return me a
> date that is 30.60 or 90 days in the future?

Reply to this Message

GTS - 30 May 2005 00:04 GMT

> I am trying to figure out if word can take todays date and then return me a
> date that is 30.60 or 90 days in the future?

Don't know if Word can do that, but you could easily make the Word doc a
merge document and have an Excel worksheet that returns these dates for you.
You could have three columns headed date plus 30, date plus 60, date plus
90, and the first row after the header would be =Today()+30, =TODAY()+60 etc
Graham

Reply to this Message

Charles Kenyon - 31 May 2005 14:20 GMT

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I am trying to figure out if word can take todays date and then return me a
> date that is 30.60 or 90 days in the future?

Reply to this Message