|
|
#12
04-06-2023, 05:47 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom Style Sets Stopped Working on Custom Template after Recent Microsoft Update | CynthiaKPollard | Word | 6 | 12-20-2021 08:37 PM |
| RibbonX Editor - change Icon for custom AutoText Gallery | Steve2081 | Word | 15 | 04-30-2021 07:58 PM |
| conditional formatting, icon sets | gohn | Excel | 3 | 06-04-2018 12:15 PM |
 QuickAccess Toolbar Icon - How to make the icon display the state of the icon's action
|
ElfegoBaca | Word | 1 | 08-13-2016 08:42 PM |
|
VBA Word - Format ALL Tables - Apply Specific Formatting to Sets of Columns – Font, Border & Width
|
jc491 | Word VBA | 10 | 11-04-2015 04:02 PM |
Windows 10 
Office 2021
Threaded Mode