Re: Calculating dates in word tables
- From: "Charles Kenyon" <wordfaq@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 14 Apr 2006 00:42:01 -0500
First you need to know how to format date fields. See
http://addbalance.com/word/datefields1.htm
You may be better off using vba here simply because I am not sure what it
takes to get date field formatting and calculations to recognize something
as a date. I've always been working from a date field. Do take a look at the
examples in the document though as a starting place if you want to try
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://word.mvps.org/FAQs/ which is awesome!
My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
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.
"Tel" <Tel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:25774090-3388-411A-B447-883D964277DB@xxxxxxxxxxxxxxxx
Thanks for this Charles and having seen your previous posts I was kinda
hoping you would respond :-)
I don't know if I'm being a bit dense, but I've looked through the links
you
sent me and I think I'm missing the basic start here. I think I need a
hand-holding step by step take me through it type of response.
Terry
"Charles Kenyon" wrote:
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
See also the MVP FAQ: http://word.mvps.org/FAQs/ 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.
"Tel" <Tel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5093924-0C10-4925-85CF-9F6B6EA44286@xxxxxxxxxxxxxxxx
At first what I wanted to do seemed so simple, now I'm not so sure.
I have two tables, Table one (Column 2, row 2) has a user input date in
it
that is a week end date (i.e. a Sunday)
The second table has a column which lists the dates of the week leading
up
to that sunday.
Therefore:
Table one date would equal 16th April 2006 (Changeable)
Table two would list from column 1 row 3 down:
10th April 2006
11th April 2006
12th April 2006
13th April 2006
14th April 2006
15th April 2006
16th April 2006
This document would form a master document. The user would change the
date
in Table 1 and I am hoping the remaining dates would take their
calculations
from that.
I am very much a novice with formulae in Word tables so if any
instructions
could be made as simple as possible that would help my simple mind.
Looking forward to your replies.
Terry
.
- Follow-Ups:
- Re: Calculating dates in word tables
- From: macropod
- Re: Calculating dates in word tables
- References:
- Re: Calculating dates in word tables
- From: Charles Kenyon
- Re: Calculating dates in word tables
- From: Tel
- Re: Calculating dates in word tables
- Prev by Date: Re: MS Word table - problem with conditional formula
- Next by Date: Re: Calculating dates in word tables
- Previous by thread: Re: Calculating dates in word tables
- Next by thread: Re: Calculating dates in word tables
- Index(es):
Relevant Pages
|
