Date Calculations

[Name]

Working with Form Fields, this is what I would like to accomplish.
I would like to enter a date, preferably using a M/d/yyyy format.
In another field, I would like a calculated date to appear, where the
new calculated date is the original date inputted, minus a defined
number of days like like 14 or 35 or 47 or whatever. For instance, if I
enter 7/23/2004, I'd like to define a field to be 11 days earlier, so
7/12/2004 automatically appears in the field.
I'd like to do this in Word; but Excel would be acceptable if necessary.
Any suggestions as to how to accomplish this would be appreciated.
Thanks.

 

[JulieD]

hi dwight

it is possible in both word & excel - and IMHO much easier in excel ... as
(as far i know, you'll have to use a macro to achieve it in word - but
someone else might have a better way) ...

to do it in excel
in cell A1 type the date
7/23/04
in cell b1 type
=A1-11

or whatever number of days you want - to make it more flexible you could use
b1 for the number of days you want to minus and then in C1 have the formula
=A1-B1

Cheers
JulieD

 

[Graham Mayor]

Such Word fields are extremely complex, but the work has been done for you
at http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Charles Kenyon]

Follow the link that Graham posted for you. Your initial date will be
assigned a bookmark and can be accessed using a REF field in the calculation
fields.
--

Charles Kenyon

See the MVP FAQ: <URL: 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.

 

[Name]

Thanks, Julie.
That's certainly a simple way.
Appreciate it.
-Dwight

 

[Name]

Such Word fields are extremely complex, but the work has been done for you
at http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

Thanks Graham (and Charles). Yes, that's exactly the type of
information I was seeking, where "the work has been done for [me]." I
could have written my ultimate project as a dedicated standalone
application in Visual Basic. But I'm in a lazy mode at the moment and
wanted to adapt it into Word. I figured someone has already done all
the work... Thanks again.
-Dwight