'Monday to Friday' Date calculation help needed

ballst · #1 12-10-2014, 02:11 PM

Hi,

Something I have been trying to get my head around for ages and just not succeeding with is automatic date calculation in word.

At my office we have a document in which a number of key future dates need to be entered, apart from those dates no text changes, so in order to speed things up for people I've tried & failed to add some kind of date function.

I've read an excellent guide on Word date & time manipulation which went pretty much straight over my head, and sadly if I don't get it my colleagues certainly won't

I've got 8 dates which need to be calculated, 6 of which are relatively straight forward.

However, the two I'm really struggling with involve two periods of between dates, for example Monday xx xx xxxx to Friday xx xx xxxx. So the date the document was issued is not an exact set period for calculation, ie the Mon-Fri dates need to be the same regardless of the day of the week the document was issued.

It's this bit my brain cannot contend with and that's why I'm asking for help.

I've attached a basic page which is the 'gist' of what I'm after. The text highlighted in blue is where date calculation needs to take place.

Any help given will be greatly received.

Ballst

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Age calculation with date and DOB fields	Xaand	Word	9	09-29-2023 11:38 AM
Rules based due date calculation	dlowrey	Excel Programming	3	05-12-2013 08:30 PM
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM