Forum Discussion
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
- Rob_ElliottBronze 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))+1Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)