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.
George_Hepworth
Mar 01, 2022Silver Contributor
This little demo might help flesh out the picture. Note that the method used, looping, will be slow on larger record sets and greater intervals. For a couple of dozen records within 30 days or less, it should be fine.
Tony2021
Mar 02, 2022Steel Contributor
Hi George, sorry but I have been busy with my real job. I probably wont be able to dig into this until Thursday or possibly later. I am looking forward to testing it.