![]() |
#1
|
|||
|
|||
![]()
I am trying to make a template for an important document here at work.
There are 2 fields we enter - Effective Date and End Date. The End Date HAS to be 5 years from the Effective Date. Sometimes this gets overlooked so I was hoping there was a way to use maybe field codes to calculate the End Date from the Effective Date we enter. I tried to use bookmarks (see example below) but came across some issues Effective Date - August 20, 2010 where August 20, is a bookmark A and 2010 is bookmark B Then for the End Date - {Ref bookmark A} {=bookmark B + 5} This gets me the end product I need but the issues I have are: *I have to make sure that if I change the year in the Effective Date that the full year is in the bookmark - if you don't change it properly then only 1/2 of the year gets bookmarked *You have to select all and update field codes ie F9. This one is doable but the other issue is too much. I am using Microsoft 2003. Please help!!! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
harvlake | Outlook | 5 | 02-24-2015 12:58 PM |
Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |