Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-06-2021, 01:22 AM
Jane Dunn Jane Dunn is offline have the date change to next work day? Windows 10 have the date change to next work day? Office 2019
Novice
have the date change to next work day?
 
Join Date: Oct 2021
Location: Europe
Posts: 1
Jane Dunn is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-06-2021, 04:16 AM
Guessed's Avatar
Guessed Guessed is offline have the date change to next work day? Windows 10 have the date change to next work day? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #3  
Old 10-07-2021, 11:16 AM
Charles Kenyon Charles Kenyon is offline have the date change to next work day? Windows 10 have the date change to next work day? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
  1. Read the introductory material completely. (You may need to run a macro.)
  2. Find the field you need.
  3. Copy and paste into your document.
Reply With Quote
Reply

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
have the date change to next work day? 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
have the date change to next work day? Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft