If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating dates in word tables
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. Therefo 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 |
#2
|
|||
|
|||
Calculating dates in word tables
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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
#3
|
|||
|
|||
Calculating dates in word tables
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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
#4
|
|||
|
|||
Calculating dates in word tables
Hi Terry,
To see how to do this and just about everything else you might want to do with dates in Word, check out my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 In particular, look under the heading 'Date Calculations in a Table' Cheers "Tel" wrote in message ... 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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
#5
|
|||
|
|||
Calculating dates in word tables
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" wrote in message ... 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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
#6
|
|||
|
|||
Calculating dates in word tables
Hi Charles,
My 'Date Calc' tutorial covers the formatting issues as well as the maths .... Cheers "Charles Kenyon" wrote in message ... 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" wrote in message ... 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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
#7
|
|||
|
|||
Calculating dates in word tables
Thanks,
It is time for me to re-read it. -- 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. "macropod" wrote in message ... Hi Charles, My 'Date Calc' tutorial covers the formatting issues as well as the maths ... Cheers "Charles Kenyon" wrote in message ... 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" wrote in message ... 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 http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 which is a document with various fields already created. Another resource is http://www.gmayor.com/insert_a_date_...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" wrote in message news 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. Therefo 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
take yet another lesson from wordperfect "reveal codes" | wordperfect is superior | General Discussion | 5 | May 11th, 2009 07:58 PM |
Word should catalog misspelled words to study. | rndthought | General Discussion | 38 | January 23rd, 2008 11:53 PM |
Converting WordPerfect 12 files to Word 2003 | Curious | New Users | 3 | March 29th, 2006 01:05 AM |
Can Wordperfect templates be converted to Word template docs | Terrill | New Users | 2 | September 14th, 2005 09:14 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |