Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2009, 08:41 AM
vandy vandy is offline Using Field Codes to Calculate 5 years from a Date Windows XP Using Field Codes to Calculate 5 years from a Date Office 2003
Novice
Using Field Codes to Calculate 5 years from a Date
 
Join Date: Aug 2009
Posts: 1
vandy is on a distinguished road
Default Using Field Codes to Calculate 5 years from a Date

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!!!
Reply With Quote
  #2  
Old 09-23-2009, 11:32 AM
RandRowlands RandRowlands is offline Using Field Codes to Calculate 5 years from a Date Windows Vista Using Field Codes to Calculate 5 years from a Date Office 2007
Novice
 
Join Date: Sep 2009
Posts: 1
RandRowlands is on a distinguished road
Default Word Date + x

I created a similar function in Word 2003, and it still worked in Word 2007. It took a bit, but here's the link.

http://www.addbalance.com/word/datefields2.htm
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Field Codes to Calculate 5 years from a Date Copy appointment to another date 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
Using Field Codes to Calculate 5 years from a Date How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM
Using Field Codes to Calculate 5 years from a Date Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft