To Add multiple or different DATEDIF cells

So you want the date differences from E3 - F3, E4 - F4, E5 - F5 etc in years, months and days ALL in the same cell?

can you mock up a sample workbook and upload it WITH expected results (hand entered and not having to be complete) so we can see what you have and what you want?

something like this in cell G8?

Formula:

Please Login or Register  to view this content.

Interesting, I've been scratching my head trying to figure out what answer you are expecting, AskMeAboutExcel's answer yields 8 years 0 months and 26 days.
But I wonder if adding up the days, months and years is the correct way? I approached it differently in taking the min of col E and max of col F and applying the datedif formula to those which yields 11 years 2 months and 2 days.
It is your data so you know what you are looking for, if you want my method I put this in col E =MIN(E3:E7) and this in col F =MAX(F3:F7) then this formula to calculate the overall date difference... =DATEDIF(E9,F9,"Y") & " Years " & DATEDIF(E9,F9,"YM") &" Months " & DATEDIF(E9,F9,"MD") &" Days "
For what it is worth.

Good point Sam, interesting that we interpreted the question differently. A good reminder that it's best to show the expected result in example worksheets...