TransWikia.com

Calculated Date Difference Question

SharePoint Asked by ZomBeezSP on December 31, 2021

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!

One Answer

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.

Answered by Chelsea_MSFT on December 31, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP