***PLEASE HELP!!!*** WORD MACRO -- Date picker in Word, using DateAdd to add six months.

Copper Contributor

I have a document with a date on it that will be changed, and that has been made into a date picker, where you click the date and it opens a calendar. I have several other places where 6 months needs to be added to that date.

 

The date picker could be replaced with text if necessary!

 

I've heard that you can easily use VBA and the function DateAdd("m", 6, Calendar) but I don't know how to dictate that the variable that I need them to add 6 months to is the Calendar date, and how to dictate where I want the output to be in the page.

 

Please help!

1 Reply
Hi @oreoicing ,

first of all: VBA is in my opinion pretty hard :D

I googled and found this, maybe it helps you.
They are not all high quality content, maybe an expert can help here more :)

http://addbalance.com/word/datefields2.htm
http://measuringuserexperience.com/Timestamp/index.htm
https://gregmaxey.com/word_tip_pages/date_time_stamp.html

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. :)