jjj/j/mmm/aaaa;;
=SIERREUR(SI(JOURSEM(INDEX($B$2:$B$100;PETITE.VALEUR(SI(($A$2:$A$100=$L2)*($B$2:$B$100>MAX($M2:M2));LIGNE($B$2:$B$100)-1);1));2)<>CHOISIR(EQUIV(N$1;{"lundi";"mardi";"mercredi";"jeudi";"vendredi"};0);1;2;3;4;5);0;INDEX($B$2:$B$100;PETITE.VALEUR(SI(($A$2:$A$100=$L2)*($B$2:$B$100>MAX($M$2:M2));LIGNE($B$2:$B$100)-1);1)));"")
pomme | 3 | sam/0/janv/1900 | sam/0/janv/1900 | mer/13/mai/2020 | jeu/14/mai/2020 | ven/15/mai/2020 |
jjj/j/mmm/aaaa;;