MACRO: @DATE Get Date for Prior/Next Day of Week [Example]
VER: 2.4 2016-12-27 ~~~
- Get the Date for the NEXT or PRIOR Day of Week (Sun, Mon, Tue, ...)
HOW TO USE:
- Set the Day of Week Number in the magenta-colored Action below
(1 = Sun; Negative for PRIOR, Positive for NEXT)
- Trigger this Macro
NOTE: If the Next/Prior Day requested is the same day of week as today, then it wlll return one week from today.
- This macro was built in response to this topic:
Macro for "Next Sunday"
2.4 2016-12-27 1:55 PM CT
- Fixed bug in PRIOR Offset. New formula is:
(((7 - DOW( ) + ABS(DATE__DayNum)) MOD 7) ) - 7