Forum Discussion
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
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
- Hello,
sorry, I do not understand what you mean with: … to show E3 = „Upper Body“
- Thanks thats the one 🙂 much appreciated
- You are welcome. If my answer help you, maybe you can mark it as best response.
BR
Chris
- Yes what is the formula you used please?
=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.
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.
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.
Thanks heaps for your help!
Please explain in detail
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?
