@DATE Get Date for Prior/Next Day of Week [Example]

date_time
example

#1

MACRO:   @DATE Get Date for Prior/Next Day of Week [Example]


VER: 2.4    2016-12-27 ~~~

DOWNLOAD:

@DATE Get Date for Prior-Next Day of Week [Example].kmmacros (12 KB)


ReleaseNotes

Author.@JMichaelTX

PURPOSE:

  • Get the Date for the NEXT or PRIOR Day of Week (Sun, Mon, Tue, ...)

HOW TO USE:

  1. Set the Day of Week Number in the magenta-colored Action below
    (1 = Sun; Negative for PRIOR, Positive for NEXT)
    .
  2. 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.

REFERENCE:


VERSION HISTORY

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


Macro for date of last Monday, Tuesday, etc?
#2

As of KM 8+, you may not need this macro. Check out this new feature of KM 8+: