With thanks to:

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 adapt the formula to be used on the Latest dates, which are always three cells on from each of the earliest dates in the range. 

Will I now be able to find the latest date (by day and month only) if I can adapt the formula that was successfully deployed for Earliest dates?

This is the formula being used for identifying Earliest dates:

 =AGGREGATE(15,6, $D3:$AQ3 /( (MONTH($D3:$AQ3)*100+DAY($D3:$AQ3)) = AGGREGATE(15,6,( MONTH($D3:$AQ3)*100+DAY($D3:$AQ3) )/NOT( MOD(COLUMN($D3:$AQ3),4) ),1)  ),1)

Here is the table so far: 

​With thanks to:Peter Bartholomew; djclementsand 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 adapt the formula to be used on the Latest dates, which are always three cells on from each of the earliest dates in the range. Will I now be able to find the latest date (by day and month only) if I can adapt the formula that was successfully deployed for Earliest dates?This is the formula being used for identifying Earliest dates: =AGGREGATE(15,6, $D3:$AQ3 /( (MONTH($D3:$AQ3)*100+DAY($D3:$AQ3)) = AGGREGATE(15,6,( MONTH($D3:$AQ3)*100+DAY($D3:$AQ3) )/NOT( MOD(COLUMN($D3:$AQ3),4) ),1)  ),1) Here is the table so far:     Read More

​