Problème de formule

%3CLINGO-SUB%20id%3D%22lingo-sub-1291322%22%20slang%3D%22fr-FR%22%3EFormula%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291322%22%20slang%3D%22fr-FR%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ERevelation%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ERevelation%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%20%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EHi%20all%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20formula%20to%20calculate%20the%20number%20of%20days%20of%20stoppages%20on%20its%20own.%20To%20make%20sure%20you%20understand%20my%20problem%2C%20here's%20an%20excerpt%20from%20the%20chart%20below%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221214%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22265.78%22%3EMonth%20of%20work%20accident%3C%2FTD%3E%3CTD%20width%3D%22230.78%22%3EYear%3C%2FTD%3E%3CTD%20width%3D%22230.83%22%3EDate%20of%20WA%3C%2FTD%3E%3CTD%20width%3D%22242.82%22%3E%3CBR%20%2F%3EEnd%20date%20of%20WA%3C%2FTD%3E%3CTD%20width%3D%22242.79%22%3ENumber%20of%20day%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22265.78%22%3ESeptember%3C%2FTD%3E%3CTD%20width%3D%22230.78%22%3E2018%3C%2FTD%3E%3CTD%20width%3D%22230.83%22%3E03%2F09%2F2018%3C%2FTD%3E%3CTD%20width%3D%22242.82%22%3E08%2F09%2F2018%3C%2FTD%3E%3CTD%20width%3D%22242.79%22%3E6%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20my%20formula%20to%20include%20the%20month%20of%20the%20accident%2C%20the%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EI'NB.SI.%20ENS%20('AT%202017%202020'!%24C%2472%3A%24C313%3B%22%20AT%20with%20stop%22%3B%20'AT%202017%202020'!%24Z%2472%3A%24Z313%3B'%20Year%20end%2019-20'!%24A7)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ECan%20you%20help%20me%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EThanks%20in%20advance%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1291322%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor
Spoiler
Spoiler
 

Bonjour à tous, 

 

Je souhaite que la formule calcule toute seule, le nombre de jours d'arrêts. Afin que vous comprenez mon problème, voici un extrait du tableau ci dessous : 

 

Month of work accidentYearDate of WA
End date of WA
Number of day
Septembre201803/09/201808/09/20186

 

Je souhaite que ma formule comprenne le mois dont l'accident s'est produit, le mois.

 

=NB.SI.ENS('AT 2017 2020'!$C$72:$C313;"AT avec arrêt"; 'AT 2017 2020'!$Z$72:$Z313;'Année fin 19-20'!$A7)

 

Pouvez vous m'aider?

Merci d'avance

0 Replies