Forum Discussion
Tatiana77330
Aug 25, 2023Copper Contributor
Sharepoint list online, formula with working days
Dear all, i need to create a calculated column in my Sharepoint List with the following instruction: if "Contractual deadline" is empty, the column "Internal deadline" has to contain "(Recei...
Rob_Elliott
Aug 25, 2023Silver Contributor
Tatiana77330 use the working days formula like the one below and adjust it to your needs:
=(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
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)