Forum Discussion
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...
im too lazy to follow the thread.
but i get the idea based on the worksheet to attached.
see your demo.
arnel_gp Interesting, but your code also returns the wrong date, the 27th, not the 26th.
I'm still unsure as to why I do get the right date and Tony doesn't from the same data and function.
I suppose I could hard code the three options specified in the original question as default number of days, but my version allows for any date and number of days calculations, hence, more flexibility for other uses.
are you referring to March month?
then your date is reversed, should be:
#3/11/2022# (US-date format) or
#2022-11-3# (iso format).
if you enter the same infor like in the worksheet it will givesame result.
- No, the date is November 3, 2022. Not March.
