Share via

How can I add x amount of working days to a date?

Lopez, Ahiezer 236 Reputation points
2023-09-12T18:15:40.18+00:00

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?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-12T19:28:45.29+00:00

    Hi

    Deleted

  2. Anonymous
    2023-09-12T20:43:57.8+00:00

    Hi

    Deleted

  3. Ken Sheridan 2,851 Reputation points
    2023-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.

     

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.