How can one calculate Dates in Word

  • Thread starter Thread starter rredbaron
  • Start date Start date
R

rredbaron

How does one put in a function within Word Document?

i.e. =Now() - 7 = Ans.

If NOW() is July 13, 2004 - 7 = July 6, 2004

I would appreciate a step by step how to insert a Formula / Function into a
Word Document.
Thanks

Regards,
Ron
 
Use the VBA DateAdd function in a macro

Format(DateAdd("d", -7, Date), "MMMM d, yyyy")

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
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.
--

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.
 
G'Day Ron,

Unless you use Visual Basic (Macros), Word will not easily do
what you require. Can you live with that?

If not, look at http://www.openoffice.org/, and you will see
a FREE download available of OpenOffice.org v1.1.1 - a full
featured office suite comprising:
Writer - Word Processor
Calc - Spreadsheet
Impress - Presentation and
Draw - Drawing.

These products are directly related to Sun StarOffice, have a
surprising degree of compatibility with MS Office, and do
seem to be stable.

Writer DOES have the facility you require. Table calculations
are considerably better featured than in Word.

Note however that once you employ this feature in Writer, you
will not be able to transfer/convert to Word.

(If you stick to a feature-set that is common to Word and Writer,
then you can open and save .doc format files in either program.)

I hope this helps.
--
Regards,
Pat Garard
Australia

______________________________________
 
Back
Top