Forum Discussion
Solved
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 r...
=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.
=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.
Thank you. This is what i needed!