Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Feb 27, 2022
Solved

Calculated Dates (taking into Account Holidays)

Hello Experts,   I am building a table: tblDatesDeliver. There are 5 fields in this table.  2 are manually entered 3 should be calculated based on the number of business days count prior   I h...
access
  • arnel_gp's avatar
    arnel_gp
    Mar 11, 2022

    Tony2021 

    im too lazy to follow the thread.

    but i get the idea based on the worksheet to attached.

    see your demo.

Tony2021's avatar
Tony2021
Steel Contributor
Mar 11, 2022

George_Hepworth 

George, I dont see any other holiday between 11/3/22 and 10/26/22 other than Halloween 10/31/22

 

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Mar 11, 2022

Tony2021 

Oops, I was thinking of Thanksgiving, not Halloween.

The only other thing I can think of is that I used dates two years in the past.
Perhaps that's causing the discrepancy?


Business Days Before: BusinessDayBeforeDate(DateAdd("yyyy",-2,[Holiday]),5)

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Mar 11, 2022

    Tony2021 

    BusinessDayBeforeDate(DateAdd("yyyy",-2,[Holiday]),5)

  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Mar 11, 2022
    What do you mean? I am not sure what is 2 years in the past?

Resources