=WORKDAY(WORKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15)-MAX(WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15),2)-5,0),-COUNTIF(A2:A10,DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15)-MAX(WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15),2)-5,0))),-COUNTIF(C2:C12,WORKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15)-MAX(WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15),2)-5,0),-COUNTIF(A2:A10,DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15)-MAX(WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(DAY(A1)<15,0,1),15),2)-5,0)))))
Bookmarks