Forum Discussion
Solved
Excel Formula for Dates
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?
Let'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.
2 Replies
Let'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.
That might work. ThanksHansVogelaar
