View Single Post
 
Old 04-06-2023, 05:47 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 346
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

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.
Reply With Quote