Challenge #86: Create a Macro that Generates Past Dates
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ch12345
7 - Meteor
10-02-2018
06:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JoBen
11 - Bolide
10-09-2018
08:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
dsmdavid
11 - Bolide
10-09-2018
02:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My verbose approach. I like more the versions with detour that I've seen above.
Spoiler
Main Workflow
Macro
JacobR77
8 - Asteroid
10-16-2018
04:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
pasccout
8 - Asteroid
10-31-2018
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Laurap1228
11 - Bolide
11-12-2018
02:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CM17
6 - Meteoroid
11-23-2018
06:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is my solution
jssandom
8 - Asteroid
12-04-2018
03:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kelly_gilbert
13 - Pulsar
12-08-2018
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was good macro practice, and not too bad considering the Advanced tag!
Spoiler
After looking at others' solutions, I'm going to go back and try this with Detour tools, which I've never used.
I handled the skip-weekends option within the Generate Rows formula


I handled the skip-weekends option within the Generate Rows formula
NilsM
8 - Asteroid
12-14-2018
05:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
my solution