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