Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Feb 27, 2022

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
What do you mean? I am not sure what is 2 years in the past?
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Mar 11, 2022

Tony2021 

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

Resources