Find Date in range of cells

[pablogiraldo]

Hi,

I have a row with a range of cells. I am trying to get a formula if the range of cells in that row contain a date, then return date, if not leave blank.

There will only be one date in that range of cells.

Looking at screenshot below:

IF F34:Y34 contain a date, then return date. In this case if i were to type this formula in cell Z34, i want 19-Jun to show up in Z34.

Thank you.

[#2 · Accepted solution]

@pablogiraldo 

=IFERROR(INDEX(F34:Y34,MATCH(TRUE,NOT(ISBLANK(F34:Y34)),0)),"")

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

[#3]

Thank you. This is what i needed!