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.
|
Thank you so much. I input various dates as you suggested, and now have both Test 1 and Test 2 scenarios working, even with changing the basic rule... I'm learning
... Now another "Q" regarding Test #3, ICON SETS "Street Lights" in cell V23. How could I apply the same rules to this version (Test#3)?
Thanks... K...