Forum Discussion

Copper Contributor

Dec 30, 2024

Removing Weekends in my if formula

I am trying to enter an if formula which takes into account only working days, so non-weekends and holidays. My formula is: =IF(O66-M66 <=3, "Yes", "No") I want my date to show Yes/No if we met a de...

Formulas and Functions

PeterBartholomew1

Silver Contributor

Jan 03, 2025

There is a catch for anyone like me who only uses array formulas.

= LET(
      daysDL, NETWORKDAYS.INTL(+deadline, +actual) - 1,
      metDL?, IF(daysDL<=3, "Yes", "No"),
    HSTACK(daysDL, metDL?)
  )

The + signs turn the multicell ranges into arrays.

Patrick2788
Silver Contributor
Jan 03, 2025
A fascinating workaround. There's no need for a Lambda helper nor a need to index it to make it suitable for NETWORKDAYS.INTL.