Reply
 
Thread Tools Display Modes
  #1   Report Post  
Leslie Draper
 
Posts: n/a
Default Word table forumla for calculating dates

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?

  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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/show...?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.
--
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
"Leslie Draper" Leslie wrote in message
...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The WordPerfect "Reveal Codes" method is so much easier to use. Torden Microsoft Word Help 8 April 19th 10 07:50 PM
Underscore (_) will not always display in RTF files (Word 2002). David A Edge Microsoft Word Help 6 June 14th 05 10:39 AM
is word perfect compatible with office word? Noreen Microsoft Word Help 1 May 11th 05 11:17 PM
creating forms Fluffypink Microsoft Word Help 4 March 9th 05 04:17 PM
letters - ask/fillin Caroline H New Users 2 February 25th 05 08:19 PM


All times are GMT +1. The time now is 12:47 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"