Forum Discussion

jonoross's avatar
jonoross
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
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 15, 2021

jonoross 

 

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.

  • jonoross's avatar
    jonoross
    Copper Contributor
    Jul 15, 2021

    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!

     

    NikolinoDE 

    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Jul 15, 2021

      jonoross 

      Please explain in detail

       

      Week DateDayStarterReservesOvertime
      Week 112.07.2021MondayYesYesNo
      Week 113.07.2021TuesdayNoNoNo
      Week 114.07.2021WednesdayYesYesYes
      Week 115.07.2021ThursdayYesNoNo
      Week 116.07.2021FridayYesNoNo
      Week 117.07.2021SaturdayYesYesYes
      Week 118.07.2021SundayYesNoNo

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

       

       

      • jonoross's avatar
        jonoross
        Copper Contributor
        Jul 15, 2021

        NikolinoDE 

         

        I have added more information on the spreadsheet which I hope clarifies things. Thanks again for helping me out

Resources