How to calculate Future Dates?

[Guest]

I already have word automatically generating the 'last saved date' of the
document, which I call the 'effective date'. This is always in the same
location and never moves.

From this I would like for word to calculate, automatically, two future
dates. This would remove the need for people to manually enter those dates
and as such make mistakes.

I would like to be able to take this effective date and generate two future
dates: Review date = (effective date + 22 months) and also Expires date =
(effective date + 24 months)

an example of this is:

Effective Date: 5 April 2006
Review Date: 5 February 2008
Expiry Date: 5 April 2008

Is there anyway to 'reference' another date and create to future dates from
this? I've done this within excel and now need the same functionality but for
word..

Help!

 

[Charles Kenyon]

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
utilities to create the fields and an explanation of different macros that
can be used instead of fields. It also has a link to
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902 which is a document
with various fields already created. Another resource is
http://www.gmayor.com/insert_a_date_other_than_today.htm.

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


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

 

[Guest]

Thanks Charles .. I didn't realise it was going to be THAT complex, so I'm
not going to do this. I'll keep trying to play around but I've had no success
even just copying and pasting previous auto text codes. I can't seem to
modify them to what I want and don't understand how in the code is specifies
delay by X number of days, months or years!

All I want is { SAVEDATE + 22 months } kind of thing!!

is there anyway in which to do the SAVEDATE - 2 month + 2 years kind of thing?

I'm going to add learning about 'field codes' to my training plan but any
help you can offer for right now I'd be very grateful.

Thanks
Cath.

 

[Charles Kenyon]

Look at the articles. Download the sample page. The formula on my page is
for number of days. I'm sorry it is complex, but it is. I am not going to do
it for you, but the page you can download has a number of examples that you
should be able to adjust to get what you want.
--
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


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

 

[macropod]

My Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
(which Charles referred you to) has a *relatively* simple field for
calculating month-based offsets. Best of all, all you may need to do is to
copy whichever one best suits your needs and change the 'delay' variable and
'DATE' to 'SAVEDATE'. All the instructions are in the file.

Cheers