=SI($B5>D$2;0;SOMMEPROD((JOURSEM(LIGNE(INDIRECT(MAX($B5;D$1)&":"&MIN($C5;D$2)));2)<=7)*((MOIS($C5)>=MOIS(D$2))+(($C5="")*(MOIS(D$1)<>1)))))
=SI(ET($B5<D$2;OU($C5>D$2;$C5=""));JOUR(D$2);SI(MOIS($C5)=MOIS(D$2);JOUR($C5);0))
=DATE(ANNEE(D1);MOIS(D1)+1;1)
=MAX(SI($C5<>"";MIN($C5;D$2);D$2)-MAX(D$1;$B5)+1;0)
=MAX(SI([@[date
de sortie]]<>"";MIN([@[date
de sortie]];D$2);D$2)-MAX([@[date d''entrée]];D$1)+1;0)