SOLVED

Excel Formula for Dates

New Contributor

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?

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@AndresUrdaneta 

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. Thanks@Hans Vogelaar