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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:25 PM.