Forum Discussion

AndresUrdaneta's avatar
AndresUrdaneta
Copper Contributor
Jul 19, 2022
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...
Excel on Mac
  • HansVogelaar's avatar
    HansVogelaar
    Jul 19, 2022

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Jul 19, 2022

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.

Resources