Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Word 2007 - Form Help - Auto-Calc a date?

Oct 5, 2010 8:59AM PDT

Hello,

I am creating a form and am using Word 2007 to make it. I have used the developer tab and created a calendar field in which the calendar drops down to allow the person inputting to select a date.

Is there a way to automatically calculate/pre-fill a date? Such as 7 days from today?

Discussion is locked

- Collapse -
Sure
Oct 5, 2010 8:51PM PDT
- Collapse -
Thanks, but....
Oct 6, 2010 3:18AM PDT

Hi, Thanks for the response!!

I tried the macro, got it to work. I'm not too familiar with them...

From what it looks like I'd have to go run the macro everytime. That's more work than just editing the date itself.

Is there any AUTOMATIC way to have the date calculated as today + 7 days? This would be a formula, I'm assuming, off the "current date" autofield.

THANKS!

- Collapse -
The problem is
Oct 6, 2010 5:42AM PDT

I have to say I rarely use Word for such calculations. I use Excel.

But as I see it, the problem is that Word never updates automatically, you always have to update the formula manually. However with a Macro you can create a Command Button that you place on the doc and assign the macro's click-event to the button. Then a one-click does the work. Here's one way to do it;
http://support.microsoft.com/kb/246299

Here's another way;
http://word.tips.net/Pages/T001571_Assigning_a_Macro_to_a_Button_in_Your_Text.html

If you want to keep trying with your formula you will need to experiment with the field (Date), and add 7. It could be as easy as (Date +7), or ( (Date) + 7), or so on.

Are you familiar with Excel? This is so much easier in Excel and the added bonus is you can copy/paste the Excel cells into a Word.doc.

Mark