Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using a Word 2007 template for a weekly activity report.

It looks like this:

I'd like to be able to just specify one date, say the first date of the week, and the others would adjust accordingly. So that the "To" date would be the entered date+5, Monday would be the same entered date (different format), Tuesday would be entered date+1, etc.

I can only see automatic dates in input fields, but those can be edited by hand, so I guess a "CreationDate" field would work, but ideally a custom date if one's available, no update required (except to referencees). But how do you reference another field and perform calculations on them?

share|improve this question
up vote 2 down vote accepted

You can surround the field with a bookmark and then use fields such as REF. However, performing calculations on dates is more complex then it sounds. Check out the following site for an example of how to do this.

share|improve this answer
I think you're going to get a Necromancer badge for this. I ended up picking the proper tool for this, which was Excel. All I had to do was convince management that it was better suited. – MPelletier Jul 10 '12 at 14:33
@MPelletier, Glad to hear you found the answer :) I agree, Excel is a much more suitable tool for this kind of thing. – Adam Jul 11 '12 at 3:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .