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...
04-06-2023, 06:45 AM
Similar Threads
QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action
Mac OS X 
Office for Mac 2011
Threaded Mode