Forum Discussion
Solved
Finding the Latest date in a range of dates
With thanks to: Peter Bartholomew; djclements and Sergei Baklan. I am nearly finished on this project that must find the earliest, latest and peak dates in a range of dates. I now need to...
Criteria which columns to select is in MOD( COLUMN(...
To select every 4th row in the range we may use criteria
MOD(COLUMN($D3:$AQ3) - COLUMN($D3)+1,4)=0
entire formula
=AGGREGATE(14,6, $D3:$AQ3 /( (MONTH($D3:$AQ3)*100+DAY($D3:$AQ3)) = AGGREGATE(14,6,( MONTH($D3:$AQ3)*100+DAY($D3:$AQ3) )/(MOD(COLUMN($D3:$AQ3) - COLUMN($D3)+1,4)=0),1) ),1)
By the way, if you have #SPILL! error that means you are on Excel 365 (or at least 2021). With that formulae could be modified, moreover we may return all result by one formula.
But since you almost finished the project, perhaps above is for future improvements.
You are adding me!? Haha