Date Calculations

  • Thread starter Thread starter Name
  • Start date Start date
N

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.
 
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
 
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.
 
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
Click to expand...
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
 
Back
Top