Calculate a Date

		Microsoft Office Forums > Microsoft Word > Mail Merge
Calculate a Date

12-09-2019, 02:43 PM

macropod

Windows 7 64bit Calculate a Date

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Using the Calculate a day, date, month and year, using n days delay example from the Microsoft Word Date Calculation Tutorial (https://www.msofficeforums.com/word/...-tutorial.html), change:

Code:

{SET jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}

to:

Code:

{SET jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045}}
{SET jd{=jd+(MOD(jd,7)>1)*2+Delay}}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to use a date to calculate an amount $.	melvin1942	Excel	13	05-22-2016 04:03 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Formula to calculate Date and Time	funkyfido	Excel	2	06-25-2013 04:25 PM
how to calculate backwards from a set finish date	ketanco	Project	1	02-07-2013 06:50 AM
Calculate date in word field	edwedw	Mail Merge	3	11-30-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.