Formule

%3CLINGO-SUB%20id%3D%22lingo-sub-2388373%22%20slang%3D%22fr-FR%22%3Eformula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388373%22%20slang%3D%22fr-FR%22%3E%3CDIV%3EI%20made%20an%20Excel%20binder%20with%2014%20sheets%20for%20data%20and%203%20%22summary%22%20sheets.%20In%20one%20of%20these%20%22summaries%2C%22%20I%20try%20to%20insert%20a%20formula%20into%20a%20cell.%20It%20is%20for%20this%20one%20that%20I%20need%20help.%20The%20formula%20should%20allow%20the%20last%20date%20to%20be%20included%20in%20the%2014%20data%20sheets.%20Am%20I%20clear%20enough%3F%20Do%20you%20have%20an%20idea%20or%20suggestion%20to%20make%20to%20me%3F%20Thank%20you%2C%20once%20again%2C%20for%20helping%20me%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2388373%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
je me suis fais un classeur Excel comportant 14 feuilles destinées à recevoir des données et 3 feuilles "sommaires". Dans l'un de ces "sommaires", je cherche à insérer une formule dans une cellule. C'est pour celle-ci que j'ai besoin d'aide. La formule doit permettre d'y inscrire la dernière date inscrite dans les 14 feuilles de données. Suis-je assez clair ? As-tu une idée ou suggestion a me faire? Merci, encore une fois, de m'aider
3 Replies

@Gilles_Robillard 

Where are the dates? Are they all in the same column on each of the data sheets, or in several columns?

@Hans Vogelaar Thank's for your help. They are all in the same column

@Gilles_Robillard 

Let's say the first data sheet is Feuil 1 and the last one Feuil 11. There should not be any summary sheet in between them.

And let's say the dates are all in column D.

The highest date is

 

=MAX('Feuil 1:Feuil 11'!D:D)