Forum Discussion

Copper Contributor

Jul 15, 2021

Solved

Formula Help

Hi guys I was wondering if any one knew a formula to search for a specific date in a column and return the value to "Yes" if true? Example below. I need the formula to search a range of cells...

excel

German_Chris
Jul 15, 2021
jonoross
Hello,
please see the attached file
=IF(COUNTIF($C$2:$C$11;B17)>0;"Yes";"No")
IF_Date.xlsx14 KB

NikolinoDE

Platinum Contributor

Jul 15, 2021

jonoross

Maybe you mean something like this ... example in the inserted file.

regards,

NikolinoDE

Datum_Yes_No.xlsx10 KB

jonoross

Copper Contributor

Jul 16, 2021

Yes what is the formula you used please?

NikolinoDE
Platinum Contributor
Jul 16, 2021
=IF($B$1=B16,"Yes","No")

thx
Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- jonoross
  Copper Contributor
  Jul 16, 2021
  Thanks Nikolino much appreciated
  - NikolinoDE
    Platinum Contributor
    Jul 16, 2021
    yw