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 f...
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.
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
