Access
A family of Microsoft relational database management systems designed for ease of use.
390 questions
Hi
Deleted
How can I add x amount of working days to a date?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
Suppose I wanted to add 85 working days, meaning only the weekdays, to a field with an existing date, how could I do this?
Same scenario, but also take into account holidays so don't count the holidays as a working day. How could I do this?
Access
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,896 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
877 questions
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-09-12T19:28:45.29+00:00 -
Lopez, Ahiezer 236 Reputation points
2023-09-12T20:14:33.7833333+00:00 Does this exclude the weekend days?
Sign in to comment -
-
Anonymous
2023-09-12T20:43:57.8+00:00 Hi
Deleted
-
Lopez, Ahiezer 236 Reputation points
2023-09-12T20:48:29.4733333+00:00 Is this done on excel vba?
-
Anonymous
2023-09-12T21:20:06.03+00:00 No, it is a VB example. You included VB in your question. VB is not VBA. Maybe you should have been more explicit in your question.
-
Lopez, Ahiezer 236 Reputation points
2023-09-12T22:17:18.01+00:00 Sorry, I couldnt find the VBA tag.
Sign in to comment -
-
Ken Sheridan 2,841 Reputation points2023-09-13T12:51:12.3033333+00:00 You might like to take a look at WorkDays.zip in my public databases folder at:
https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169
This little demo file illustrates the use of a number of functions for doing working days arithmetic, including for the addition/subtraction of working days to/from a date. Versions of the functions are given for use in a single country with a single public holidays regime, or in multiple countries with different public holidays regimes, such as the constituent countries of the UK.
-
Lopez, Ahiezer 236 Reputation points
2023-09-13T15:57:49.0666667+00:00 There appears to be nothing
Sign in to comment -