Forum Discussion
Darrio
Mar 16, 2023Copper Contributor
Calculate Active Days in Recurring SharePoint Calendar
I am looking for a formula to calculate the active days of a recurring SharePoint calendar event. I created a simple formula to calculate the number of days based on the start date and end date, (=[E...
RobElliott
Mar 16, 2023Silver Contributor
Darrio to calculate the number of working days (Monday-Friday) between 2 dates which in my list are Start and End, add a calculated column and use the following formula:
=(DATEDIF(Start,End,"D"))-INT(DATEDIF(Start,End,"D")/7)*2-IF(WEEKDAY(End)<WEEKDAY(Start),2,IF(OR(WEEKDAY(End)=7,WEEKDAY(Start)=1),1,0))
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)