Forum Discussion
searching for dates to trigger an action.
I am using a Mac with Microsoft 365. I have another question regarding using Excel. My spreadsheet involves three columns and many rows. I am trying to design a formula to allow me to search Colum...
Thank you.That is good to know but the dates I need to look for are (<= 1875) and (>= 1899).
jhicks5charternet
If you only want to search a value in your Text >=1875 an <=1895 you can use this formula in your conditional formating rule:
=SUM(IFERROR(FIND(SEQUENCE(21;;1875);B2);0)) < maybe you have to repace semicolon with comma
- Chris, I Tried using The above formula after substitution of the "," and it worked somewhat. It did not pick the proper dates. In fact I can't figure out why it picked what it did, /Users/john/Desktop/Screen Shot 2021-07-07 at 1.36.38 PM (2).png
John- @jhicksScharternet
I think you want to show a screenshot, but it doesn`t show here. Please try again.