Next first Friday of the month?
-
Our organisation has a meeting which is always on the first Friday of the month at 6 pm. I want to include a shortcut to say when the next meeting will be. Using “first Friday of next month” does not work for the following reason:
For example, let’s say that “today” is Wednesday 2 September. I want the shortcode to return Friday 4 September, but the parameter above would return the first Friday in October.
So, what I really want is something like “next 6 pm on first Friday of the month” (which I realise is incorrect syntax!), so that if we are already past 6pm on the first Friday of this month, it returns a value for next month, otherwise it returns a value for this month.
Grateful for any suggestions.
- The topic ‘Next first Friday of the month?’ is closed to new replies.