Repeating Events the same Monday of the month

3

hi @Miguel_Gomez ,

I guess this question has be put forward in many variations already and that therefore the pack suggestion of @Samuel_Langford is very useful. If you want to generate a list of values without a pack see my contribution below.

to get all Mondays in any given list of dates - I constructed this list via the Sequence(), you apply:

Sequence(Today(),Today()+365).Filter(
  CurrentValue.Weekday().Contains(2)).
  FormulaMap(CurrentValue.ToDate())

When you only want to have this list for unique months, you add an element to this filter in our case we ask also if the day is a number between 1 and 7

Sequence(Today(),Today()+365).Filter(
CurrentValue.WeekdayName().Contains("Monday") and 
CurrentValue.Day().Contains(1,2,3,4,5,6,7)).ForEach(CurrentValue.ToDate())

In my screenshot I replaced the Weekday() logic for a weekdayName() since I don’t know what kind of week logic you follow.

image
image1552×555 67 KB

Anyway a pack (or even better a native Coda integration) will for most users likely be the way forward, cheers, Christiaan

3 Likes