WORDAY FORMULA

Hi

Could anyone help me amend this formula to count working days rather than days please?

=IF(AND([IMMUNISATION INCIDENT REPORT FORM SENT]@row > DATE(2020, 1, 1), [IRRF RECEIVED]@row = 0), [IMMUNISATION INCIDENT REPORT FORM SENT]@row + 10, IF(AND([IMMUNISATION INCIDENT REPORT FORM SENT]@row > DATE(2020, 1, 1), [IRRF RECEIVED]@row = 1), "RECEIVED"))

Thank you

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!