![]() |
#7
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Xaand | Word | 9 | 09-29-2023 11:38 AM |
![]() |
dlowrey | Excel Programming | 3 | 05-12-2013 08:30 PM |
![]() |
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 |