Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2016, 08:36 AM
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


This requires complex fields. Word is not built to do it easily.
See the Date Calculation Tutorial and download it. It should have the fields you want or something close enough you can easily modify them to meet your needs.

Last edited by Charles Kenyon; 05-18-2020 at 11:16 AM.
Reply With Quote
  #2  
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
  #3  
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
  #4  
Old 05-18-2020, 08:16 AM
BoatinBabe BoatinBabe is offline Inserting a formula to count 30 days before and after a date in WORD table Windows 10 Inserting a formula to count 30 days before and after a date in WORD table Office 2013
Novice
 
Join Date: May 2020
Posts: 1
BoatinBabe is on a distinguished road
Default Tutorial link is missing

Quote:
Originally Posted by Charles Kenyon View Post
This requires complex fields. Word is not built to do it easily.
See the Date Calculation Tutorial and download it. It should have the fields you want or something close enough you can easily modify them to meet your needs.
Hi Charles - this tutorial link is Dead. Do you have another that works?
Reply With Quote
  #5  
Old 05-18-2020, 11:14 AM
Charles Kenyon Charles Kenyon is offline Inserting a formula to count 30 days before and after a date in WORD table Windows 10 Inserting a formula to count 30 days before and after a date in WORD table Office 2019
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 BoatinBabe View Post
Hi Charles - this tutorial link is Dead. Do you have another that works?

It is one of the pinned threads in this forum!
Microsoft Word Date Calculation Tutorial


I will change the earlier posts.
For those who have not registered in this forum, a copy is also on Graham Mayor's website.
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:55 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