View Single Post
 
Old 12-10-2014, 02:11 PM
ballst ballst is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2014
Posts: 32
ballst is on a distinguished road
Default 'Monday to Friday' Date calculation help needed

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
Attached Files
File Type: doc DateCalculation.doc (39.5 KB, 14 views)
Reply With Quote