User Profile
realKarimSaleh
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
SharePoint list code syntax check
Hi I would really appreciate some insight as I have been stuck with my Formula for a calculation column in my SharePoint List as I have been getting syntax error. Here is what I am hoping to achieve with the formula. Calculate and output the days between Start Date and End Dates while excluding weekends and Also to exclude (From a Different List that has Holiday dates) the dates between Holiday Start Date and Holiday End Date while excluding Weekends as well. Here is my Formula - =IF(AND(WEEKDAY([Start Date],2)<6, WEEKDAY([End Date],2)<6),INT(([End Date]+1)-([Start Date]+1))-INT((([End Date]+1)-([Start Date]+1))/7)*2-IF(OR(WEEKDAY([Start Date],2)=7,WEEKDAY([Start Date],2)=1),1,0)-IF(OR(WEEKDAY([End Date],2)=7,WEEKDAY([End Date],2)=1),1,0)-SUM(IF(([Start Date]>=VacationDates[Start Date])*([Start Date]<VacationDates[End Date]),1,0)*((WEEKDAY(VacationDates[Start Date],2)<6)*(WEEKDAY(VacationDates[End Date],2)<6))),0) I would really prevaricate some helpSolved4.3KViews0likes2Comments
Recent Blog Articles
No content to show