I can do this in Excel with ease but after a couple hours of online research, I can't figure out how to do this in Word 2010.

I have figured out it has to be done in a table, and if I'm correct, have named the cells correctly in my description below.

I have attached a Word 2010 Docx.



I want to add a date in the yellow box in this table. R2C1

In R2C2 I want a date to automatically appear that is 30 days Before R2C1

In R2C3 I need a date to automatically appear that is 30 days After R2C1

I would be very grateful for a solution, if there is one

Attached Files

Date Signed.docx (15.2 KB, 21 views)

This requires complex fields. Word is not built to do it easily.
See the Date Calculation Tutorial and download it. It should have the fields you want or something close enough you can easily modify them to meet your needs.

Charles... Thank you for your help. I've read through your document several times and unfortunately, I'm not savvy enough with the underbelly of the language or the functionality of Word and was unable to figure this out. I am grateful for your assistance.

It has been a while since I've looked at this.

1. Download the tutorial document and open it. Be sure to read through the introductory material.
2. Find a field that looks like it does what you want. Select that field and press Alt+F9 to toggle display of field codes. You will jump in the document because it will become longer. Press your right or left arrow key to come back to your page.
3. Look for a set Delay command or something similar. That is the number of days. You can modify that. Look to see where it is getting its original date. That is generally some sort of bookmark or one of the date fields.
4. Remember to press Alt+F9 again when you are done looking at or modifying any fields.

The field I am looking at is:
{QUOTE{SET Delay 14}{SET a{=INT((14-{DATE \@ M})/12)}}{SET b{={DATE \@ yyyy}+4800-a}}{SET c{={DATE \@ M}+12*a-3}}{SET d{DATE \@ d}}{SET jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}{SET e{=INT((4*(jd+32044)+3)/146097)}}{SET f{=jd+32044-INT(146097*e/4)}}{SET g{=INT((4*f+3)/1461)}}{SET h{=f-INT(1461*g/4)}}{SET i{=INT((5*h+2)/153)}}{SET dd{=h-INT((153*i+2)/5)+1}}{SET mm{=i+3-12*INT(i/10)}}{SET yy{=100*e+g-4800+INT(i/10)}}"{dd}-{mm}-{yy}" \@ "dddd, d MMMM yyyy"}



Again, read the introductory material, do not try to type this thing. You want to copy a field from the page as a whole and modify it.


Change Delay to 30 from 14. That will give you a Date 30 days from the current date. If you change later on "+Delay" to "-Delay" it will give you 30 days before the current date.

See also Calculated Dates in Microsoft Word using Fields or vba.

In the field solution if you put these fields in a template and use the CreateDate field instead of the Date field when a document is created based on the template, you could have the CreateDate field, itself, as the base date and your other two dates will calculate automatically.

You may also want to look at http://gregmaxey.com/word_tip_pages/...ted_dates.html.

As you may have gathered, this is not for the faint-at-heart.

It definitely is not. I again, thank you and will tackle this project again tomorrow. The short story is that I deliver a locked down Word document daily to people. There is a text form field in it where they have to manually type a date. Next to that, amid a sentence, are 2 more text fields. Hoping this process will end in those 2 fields auto-populating (30 days before and after) based on the users manual date entry. Your answers lead me to believe I don't need the table to accomplish this. I'll keep you posted, and thank you.

I believe that you can use a bookmarked date, but I am not sure how. I think the DatePicker control could be crucial to getting the beginning date to be recognized.

No, it doesn't need to be in a table, but the attached implementation of the field codes from my tutorial with your document maintains your table.

Attached Files

Date Signed.docx (17.1 KB, 43 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Charles - this tutorial link is Dead. Do you have another that works?

It is one of the pinned threads in this forum!
Microsoft Word Date Calculation Tutorial


I will change the earlier posts.
For those who have not registered in this forum, a copy is also on Graham Mayor's website.