I'm supporting with documentation weekly events that occur on Wednesdays starting on 8/26 with some dates excluded for holidays.
What's a way that I could paste these dates by referencing the week number relative to the starting date? For instance, when I receive something from a colleague who wants to add to week 13, I want KM to tell me which Wednesday date that was, and if further requested, format the date as YYYY.MM.DD ready to paste.
Unless there's an algorithmic way to determine which weeks you're going to skip (my guess is "no," since you didn't provide one) I would say the easiest macro to write and maintain is one that defines a text variable with lines that contain all the "legal" Wednesdays in the format you want.
It then plucks the one you want from that list based on a number you give it. Because I couldn't find a function or action to extract a particular line from text, I wrote a Perl one-liner to convert the lines shown above into a JSON array. Then I was able to use JSONValue to get the date with the given index.
Here's the macro. It includes only the first six weeks of the list you gave, but it's easy to add the rest and then update it periodically as time goes on. Also, it just pastes the date because I wasn't sure what else you wanted to do.
Thank you so much! I didn't make it clear, but the list in my original post was all the Wednesdays I need, with the holidays already removed. So I added the remaining dates into your macro and it works like a charm.
Love this forum, this software, and the users of both.