Forum Discussion
Re: Calculate Due Dates, excluding Holidays and Weekends
I forgot to add, the formula I've tried is =workday(H4,7) and it's not giving me the correct due date.
H4 = first date in the "Date accepted" column.
Excel is returning the date 7/16/2025 instead of 7/15/2025, which would be 8 business days, instead of the needed 7.
2 Replies
Which days of the week are business days and which ones are weekend dates in your region?
Hey Hans,
Thank you for your assistance. Another gave me the answer:
=WORKDAYS( A1,7, Holidays) -NETWORKDAYS(A1, A1, Holidays)
