Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-11-2014, 03:45 PM
ballst ballst is offline 'Monday to Friday' Date calculation help needed Windows XP 'Monday to Friday' Date calculation help needed Office 2003
Advanced Beginner
'Monday to Friday' Date calculation help needed
 
Join Date: Dec 2014
Posts: 32
ballst is on a distinguished road
Default

I can confirm that I am using Select All / Ctrl-A before updating the issue date and it doesn't seem to make a difference, as per the attached.

Re Point D, the 7 & 12 weeks should count from the preceeding Monday.

Regarding the actual text, it says something along the lines of... Between Monday dd/mmm/yyyy - Friday dd/mmm/yyyy parties are to return document outlining dates of availablity between dd/mmm/yyyy and dd/mmm/yyyy which is the target date (this date is manually entered, as it is not fixed.)

Hope this helps.
Attached Files
File Type: doc DateCalculationA.doc (52.0 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
'Monday to Friday' Date calculation help needed Age calculation with date and DOB fields Xaand Word 9 09-29-2023 11:38 AM
'Monday to Friday' Date calculation help needed Rules based due date calculation dlowrey Excel Programming 3 05-12-2013 08:30 PM
'Monday to Friday' Date calculation help needed 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:53 AM.


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