SOLVED

# Find Date in range of cells

Copper Contributor

# Find Date in range of cells

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 Replies
best response confirmed by pablogiraldo (Copper Contributor)
Solution

# Re: Find Date in range of cells

``=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.

# Re: Find Date in range of cells

Thank you. This is what i needed!
1 best response

Accepted Solutions
best response confirmed by pablogiraldo (Copper Contributor)
Solution

# Re: Find Date in range of cells

``=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.