Quote:
Originally Posted by kilroyscarnival
As far as I can see, yes. That formula is wider than what is displayed there.
The important factor is, does it actually work?
Try plugging in different dates in the original date field (M2).
Exactly 120 days ago today (6-Apr) would be 7-Dec-2022.
116 days ago would be 11-Dec, and 126 days ago 1-Dec. So 127 days ago would be 30-Nov-22.
If you put in those dates you should see the various results expected.
|
Quote:
Originally Posted by Pecoflyer
To be on the safe side please post a sample sheet with some data ( no pics please). Thx
|
Hello... I did send an apology for being tardy about acknowledgement of your previous post. Hoping you can help with this "NEW" Work book Sheet, Condition Format Test #1,2,3 ... TEST#3: ICON SET 'Signal Lights' (x3) see attached. I have created this sheet to learn about CF, Test 2 is really a renamed version of test #1 and both work. I would like to see if I can apply the 'ICON SET' to the same rules. Any help would be appreciated or at least point me in a good direction.
Thanks
Kw...
