List of Dates if COUNTA = 5 and greater than Today()

[welshraz]

I have created a calendar to easliy track leave etc. of a team. There is conditional formatting in place that highlights dates that may cause us issues. What I would like is a formula that finds the dates that meet this criteria, and lists them. I do not know if what I am asking is possible....maybe some sort of spill formula, but I have never used it to reference rows rather than columns?

What I'm looking for is if any cell in row 16 is greater or equal to 5, and the date is greater than Today(), then list the date from the corresponding column in row 3.

Thanks is advance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[welshraz]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks. All updated. Currently using 365

 

[Fluff]

Thanks for that.
How about

=FILTER(AL3:EK3,AL16:EK16>=5)

 

[welshraz]

Thanks for that.
How about

=FILTER(AL3:EK3,AL16:EK16>=5)

That is perfect! I've added additional criteria and Transpose, and it works a treat.

Thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback.