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!