![]() |
#1
|
|||
|
|||
![]()
Hello people,
I need help with the date field to calculate a future date and that it would skip weekends and holidays. I was reading through several forums and tutorials and found out that it's surprisingly complex. I have no idea how to make this. The idea is as follows: Today's date = January 21, 2016 - I need the date to be 3 days in the future while excluding the weekend and let's imagine that there is also a holiday on Monday next week. The calculated date then would be January 27, 2016 - of course the code in the field would have to take into account the number of days in each month to smoothly go to the next month. The date would be calculated each time the document is opened. From what I've seen so far I understand that such thing is quite complex and I'm not even sure it works this way. Is there anyone who could help me with this? The best would be if someone attached a word document with this field already coded and I would just save it to copy it in all the documents. Thanks in advance for any ideas ![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Adding text before a date merge field AND fomatting date as well | NikkiR | Mail Merge | 1 | 08-06-2014 07:18 PM |
Date field inserting merge date in blank field | Lesley | Mail Merge | 5 | 09-30-2013 01:49 AM |
![]() |
cosmopolitan | Word VBA | 1 | 08-14-2013 01:58 PM |
![]() |
Erbwon | Word | 6 | 11-12-2012 06:17 PM |