Word table forumla for calculating dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie Draper - 26 Jun 2005 23:19 GMT

Is there a formula that i can use in a word table cell that will take a date
from one call and add a few days to automatically calculate the new date. In
Excel you type in the date + 45 and you get a new date 45 days later, for
example.
Can this be done in a word table?
lesliedraper@cfl.rr.com

Reply to this Message

Doug Robbins - 27 Jun 2005 07:24 GMT

Not so easily in Word.

You can use the DateAdd function in a macro to do it, or or see:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

for a method of doing it with fields.

You may however want to consider just inserting an Excel spreadsheet into
the document rather than using a Word table.

Except when you are actually working in the spreadsheet, it can look like a
Word table, and you will then have all of the cell formatting/calculation
ability that is available in Excel.

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

> Is there a formula that i can use in a word table cell that will take a
> date
[quoted text clipped - 4 lines]
> Can this be done in a word table?
> lesliedraper@cfl.rr.com

Reply to this Message