1

Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems like a stupid question but I'm no guru with formulas as you can see.

I'm working with SP Online and trying to create a simple calculation to show the span of business days between submission and approvals from our customer. Currently have the below calculation but this gives total days including weekends.

=[Date sent to Customer]-[Customer Approval Date]

I've tried to use this next formula to take business days into account but it doesn't like it. What am I doing wrong?

=NETWORKDAYS[Date sent to Customer]-[Customer Approval Date]

Any help would be GREATLY appreciated!

Improve this question
1

1 Answer 1

Reset to default
0

The NETWORKDAYS function in Excel does not apply to SharePoint Online calculated columns. You can refer to the document here for all supported formulas in SPO.

Consider using the WEEKDAY function instead, see an example here: Calculating Dates Excluding Weekends.

Improve this answer
1
  • Thank everyone very much for the help!
    – ZomBeezSP
    Commented Aug 17, 2020 at 20:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.