Sharepoint list online, formula with working days

[Tatiana77330]

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

[#2]

@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)