#1
|
|||
|
|||
have the date change to next work day?
hello, first time poster, I was just wondering if there was any conceivable way to have the date change to next work day, based on pre existing date. I have to use word to make employee contracts and this would save me valuable seconds!
example I enter "employee contract date: 10.10.2021" and id like a formula that would take that date and fill it out for "employee's ACTUAL work day starts in next available work day after 10.10.2021" so if its a Friday it be that date plus 3, and if its a Monday-thrusday it be plus 1, but there are also official holidays, which would make it a little more tricky. Just wondering if this is even achievable, like a calendar type formula? please and thank you |
#2
|
||||
|
||||
There is a Date Fields resource pinned at the top of this forum which contains all the information you need to do this. You can also find previous threads that discuss the same requirement eg https://www.msofficeforums.com/word/...-business.html
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Yes it is possible. It is not easy but the heavy lifting was done by Paul Edstein. The pinned resource is Microsoft Word Date Calculation Tutorial.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Event to change cell in same row doesn't work if user clicks other row | Peterson | Excel Programming | 4 | 05-10-2021 04:59 PM |
Change font color if date in column F is prior to today's date. | kevinbradley57 | Excel Programming | 1 | 12-05-2018 07:35 PM |
Selecting a Date in Date Picker and Having it change dates throughout | joshuaran | Word VBA | 2 | 03-14-2018 09:24 PM |
Fixing Work, % of actual work and Final Date in a task (while assigning resources) | Campelliann | Project | 1 | 01-09-2017 06:15 PM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |