Forum Discussion
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...
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?
I have added more information on the spreadsheet which I hope clarifies things. Thanks again for helping me out
- 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?