calcul date excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2535777%22%20slang%3D%22fr-FR%22%3Eexcel%20date%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535777%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20up%20numbers%20of%20dates%20(by%20month%20and%20by%20year).%20the%20formula%20%3DNB.SI('agents%20H-Z'!%24E%242%3A%24E%24141%3B%22%20*Jan%2F2021%22)%20doesn't%20give%20me%20any%20results...%20thank%20you%20for%20your%20advice%2C%3C%2FP%3E%3CP%3ECdlt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2535777%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2535803%22%20slang%3D%22en-US%22%3ERe%3A%20calcul%20date%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1100569%22%20target%3D%22_blank%22%3E%40GGauthier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20day%3CBR%20%2F%3ENot%20really%20clear%20I'm%20afraid.%20Could%20you%20follow%20the%20guidelines%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%20and%20upload%20a%20small%20representative%20sample%20of%20what%20you%20have%20and%20what%20you%20expect%3C%2FP%3E%3CP%3E%3D%26gt%3B%20This%20will%20help%20to%20help%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

Je souhaiterai additionner des nombres de dates (par mois et par année). la formule =NB.SI('agents H-Z'!$E$2:$E$141;"*janv/2021") ne me donne pas de résultats... merci de vos conseils,

Cdlt,

 

1 Reply

@GGauthier 

Good day
Not really clear I'm afraid. Could you follow the guidelines from Welcome to your Excel discussion space! and upload a small representative sample of what you have and what you expect

=> This will help to help you