Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 12-12-2014, 06:18 AM
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

Macropod,

Thanks again for the reply.

I've been trying this one again this morning, but with only limited success.

1. The dates now automatically calculate, so thank you. However as soon as you print, or even preview print all the dates revert to the same day. For example if you take 01/01/2015 as date of issue all the other dates revert to 26/03/2015. The dates will remain as incorrect until you change the Issue date, however again any attempt to print renders it faulty.

2. Re the dates in Point D, for info the target date should be 126 days from the date of issue, so the flexibility of the additional input box is a great solution for those that slip. For reference the first date of availability is always a Monday, so it could perhaps be linked to the first date calculation in D, i.e the date the document is to be returned? If so the first week of availability is always 5 weeks after the document is due.


Ballst
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 07:35 PM.


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