Jul 18 2022 05:28 PM - edited Jul 18 2022 07:08 PM
Hi, I’m in real estate in the state of Florida, in the for sale contract the days between two dates are always counted no matter if it is a weekend or a holiday. Nonetheless, if the expiration date falls into one of those days (weekend or holiday), then the expiration day should be moved to the next business day. What will be the formula to use?
Jul 18 2022 11:35 PM
SolutionLet's say the start date is in D2 and the number of days in E2, and you have a range of public holidays named (hah!) Holidays.
=WORKDAY(D2+E2-1,1,Holidays)
This can be filled down.
Jul 18 2022 11:35 PM
SolutionLet's say the start date is in D2 and the number of days in E2, and you have a range of public holidays named (hah!) Holidays.
=WORKDAY(D2+E2-1,1,Holidays)
This can be filled down.