Find Date in range of cells

Copper Contributor



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)



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

find date.JPG

Thank you. This is what i needed!