Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2016, 12:01 PM
bjh894 bjh894 is offline Inserting a formula to count 30 days before and after a date in WORD table Windows 7 32bit Inserting a formula to count 30 days before and after a date in WORD table Office 2010 32bit
Novice
Inserting a formula to count 30 days before and after a date in WORD table
 
Join Date: Jun 2016
Posts: 3
bjh894 is on a distinguished road
Default

Charles... Thank you for your help. I've read through your document several times and unfortunately, I'm not savvy enough with the underbelly of the language or the functionality of Word and was unable to figure this out. I am grateful for your assistance.
Reply With Quote
  #2  
Old 06-15-2016, 02:17 PM
Charles Kenyon Charles Kenyon is offline Inserting a formula to count 30 days before and after a date in WORD table Windows 8 Inserting a formula to count 30 days before and after a date in WORD table Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by bjh894 View Post
Charles... Thank you for your help. I've read through your document several times and unfortunately, I'm not savvy enough with the underbelly of the language or the functionality of Word and was unable to figure this out. I am grateful for your assistance.
It has been a while since I've looked at this.

  1. Download the tutorial document and open it. Be sure to read through the introductory material.
  2. Find a field that looks like it does what you want. Select that field and press Alt+F9 to toggle display of field codes. You will jump in the document because it will become longer. Press your right or left arrow key to come back to your page.
  3. Look for a set Delay command or something similar. That is the number of days. You can modify that. Look to see where it is getting its original date. That is generally some sort of bookmark or one of the date fields.
  4. Remember to press Alt+F9 again when you are done looking at or modifying any fields.
The field I am looking at is:
{QUOTE{SET Delay 14}{SET a{=INT((14-{DATE \@ M})/12)}}{SET b{={DATE \@ yyyy}+4800-a}}{SET c{={DATE \@ M}+12*a-3}}{SET d{DATE \@ d}}{SET jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}{SET e{=INT((4*(jd+32044)+3)/146097)}}{SET f{=jd+32044-INT(146097*e/4)}}{SET g{=INT((4*f+3)/1461)}}{SET h{=f-INT(1461*g/4)}}{SET i{=INT((5*h+2)/153)}}{SET dd{=h-INT((153*i+2)/5)+1}}{SET mm{=i+3-12*INT(i/10)}}{SET yy{=100*e+g-4800+INT(i/10)}}"{dd}-{mm}-{yy}" \@ "dddd, d MMMM yyyy"}



Again, read the introductory material, do not try to type this thing. You want to copy a field from the page as a whole and modify it.


Change Delay to 30 from 14. That will give you a Date 30 days from the current date. If you change later on "+Delay" to "-Delay" it will give you 30 days before the current date.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a formula to count 30 days before and after a date in WORD table Date field - future date calculation + only business days neon4 Word 7 01-21-2016 02:21 PM
Inserting a formula to count 30 days before and after a date in WORD table How to count even exact date 90 days redza Excel 1 09-17-2013 03:36 AM
Word Count Formula clau_dos Word VBA 1 08-27-2013 02:05 PM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
Inserting a formula to count 30 days before and after a date in WORD table Inserting a date calculated from a table cell theMikeD Word 2 09-11-2012 05:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


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