Forum Discussion

Copper Contributor

Feb 28, 2022

Solved

Sharepoint count workdays with ISBLANK

Hi! I'm new to the sharepoint platform and currently working on a project where it will count the number of days from "Start Date" to "End Date" excluding weekends and if the End date ISBLANK, it...

microsoft lists

SharePoint Online

sharepoint server

RobElliott
Feb 28, 2022
ash052621 to get you started the formula for the number of working days between the StartDate and EndDate columns is as follows:

=(DATEDIF([StartDate],[EndDate],"D"))-INT(DATEDIF([StartDate],[EndDate],"D")/7)*2-IF(WEEKDAY([EndDate])<WEEKDAY([StartDate]),2, IF(OR(WEEKDAY([EndDate])=7,WEEKDAY([StartDate])=1),1,0))+1

But I'd have to give more thought to the ISBLANK aspect of this, unless someone else has any thoughts.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott

Silver Contributor

Feb 28, 2022

ash052621 to get you started the formula for the number of working days between the StartDate and EndDate columns is as follows:

=(DATEDIF([StartDate],[EndDate],"D"))-INT(DATEDIF([StartDate],[EndDate],"D")/7)*2-IF(WEEKDAY([EndDate])<WEEKDAY([StartDate]),2, IF(OR(WEEKDAY([EndDate])=7,WEEKDAY([StartDate])=1),1,0))+1

But I'd have to give more thought to the ISBLANK aspect of this, unless someone else has any thoughts.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)