Forum Discussion

Tatiana77330's avatar
Tatiana77330
Copper Contributor
Aug 25, 2023

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 "(Received date)+ 7 working days" if "type of case" is "spontaneous" or "(Received date)+ 10 working days" if "type of case" contains another value than "Spontaneous".

 

but it's a nightmare because it don't find the right formula for the calculation of working days in SP List...

 

Someone can help me?

 

thank you

 

Kind regards

Tatiana

SharePoint Online
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Aug 25, 2023

    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)

Resources