Forum Discussion
Tony2021
Feb 27, 2022Steel Contributor
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...
- Mar 11, 2022
im too lazy to follow the thread.
but i get the idea based on the worksheet to attached.
see your demo.
Tony2021
Steel Contributor
Hello George, sorry for my tardy reply. I looked it over and it looks good but I ahv a follow up if you coujld be so kind.
If I enter 11/3/2022 and a holiday is 10/31/2022 then 5 days prior should be: 10/26 but i think it returns 10/27 in column Business Days Before.
I am not sure if I am entering the data correctly though and/or understand how it works.
Could you kindly assist?
If I enter 11/3/2022 and a holiday is 10/31/2022 then 5 days prior should be: 10/26 but i think it returns 10/27 in column Business Days Before.
I am not sure if I am entering the data correctly though and/or understand how it works.
Could you kindly assist?
George_Hepworth
Mar 08, 2022Silver Contributor
I'll have to make time today to revisit that. If the Holiday is in the holiday table, it should work the same as other date ranges.