Using Excel Date Formula in Word (or similar)

[UndwaterExcelWeaver]

<article>

I have a few weekly forms at work that are Word documents made up of tables. I'd like to use the Today() function in these tables and then Today()+1...+2, etc to automatically update the dates for a full week. I know how to do this in excel but I can't figure out any way to may it work in a word doc table. I know Word has different Date fields so if I just need to use a specific date field to accomplish the same task then that would work to but after hours of googling and failed attempts I'm about at my wits end. Please help!
​

</article>

 

[UndwaterExcelWeaver]

Or alternatively, how to create a macro which will open an excel document with the formulas there and then paste them back into the word document. I haven't had any luck trying this either.

 

[Fluff]

Cross posted https://chandoo.org/forum/threads/excel-date-code-in-word.41084/

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Macropod]

To see how to do this and just about everything else you might want to do with dates in Word using field coding, check out my Microsoft Word Date Calculation Tutorial, at:
http://www.msofficeforums.com/word/38719-microsoft-word-date-calculation-tutorial.html
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled Calculate a Date Sequence. The complexity will probably make your eyes water... but at least you can simple copy/paste the field codes from the tutorial into your own document. Do read the document's introductory material.

By comparison, using a macro is a trivial undertaking.