SOLVED

# Formula Help

Occasional Contributor

# 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 and identify 7/12/2021 and return the answer to Yes. Do I use the IF function?

15 Replies

# Re: Formula Help

Here is a small example with Yes and No.
Formatted the date cells to text.

I would be happy to know if I could help.

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.

# Re: Formula Help

Hi NikolinoDE

Thanks for your response but I require the formula to be able to identify the date from a date range. I have reattached your spreadsheet with an explanation which I hope clarifies what I need.

# Re: Formula Help

 Week Date Day Starter Reserves Overtime Week 1 12.07.2021 Monday Yes Yes No Week 1 13.07.2021 Tuesday No No No Week 1 14.07.2021 Wednesday Yes Yes Yes Week 1 15.07.2021 Thursday Yes No No Week 1 16.07.2021 Friday Yes No No Week 1 17.07.2021 Saturday Yes Yes Yes Week 1 18.07.2021 Sunday Yes No No

You need in E17 a formula but i can not understand why is a Yes or No in the other dates?

# Re: Formula Help

As I understand it, No should then appear in C18 to C23. For you it is sometimes yes and sometimes no, without meaning. It's extremely confusing. Is the yes or no just for the show there, or have I misunderstood something?

# Re: Formula Help

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

regards,

NikolinoDE

best response confirmed by allyreckerman (Microsoft)
Solution

# Re: Formula Help

Hello,

``=IF(COUNTIF(\$C\$2:\$C\$11;B17)>0;"Yes";"No")``

# Re: Formula Help

Yes what is the formula you used please?

# Re: Formula Help

Thanks thats the one much appreciated

# Re: Formula Help

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

# Re: Formula Help

Thanks Nikolino much appreciated

BR
Chris

yw

# Re: Formula Help

Hi Chris

I also need the formula to show E3="Upper Body". How would I add this into formula =IF(COUNTIF(\$C\$2:\$C\$11;B17)>0;"Yes";"No")

Thanks

# Re: Formula Help

Hello,
sorry, I do not understand what you mean with: … to show E3 = „Upper Body“