Need to find the "other" date

[asjmoron]

Hey guys,

I have a row with three dates. I can use min and max to find the oldest and newest but I need to find the date that sits between them (as it is written in the cell not as an exact date between the oldest and newest).

Hope that makes sense

 

[AlanY]

try

large(..,2) or small(...,2)

 

[asjmoron]

OMG...ofcourse... this is a classic case of overthinking!

Thanks

 

[AlanY]

you're welcome

it's Friday after all