Is there a formula for first Tuesday of the month?

1

I expect to give it the year and the month and have it return the first tuesday.

2

hello @Bruce_Axtens , thanks for asking
I wonder what options you tried before you posted the question, here you find the details:

below in a few steps how you get there

  • I created sub tables with the weekdays and months I used as look-ups
  • I created the first date of the respective month
  • I filtered on the the first Tuesday, but It can be any weekday

this part creates the date

Format("{1}/{2}/{3}",thisRow.Months.MonthNumber,1,thisRow.Year.ToText())

this is the filter

Sequence(thisRow.date,thisRow.date.EndOfMonth(0)).filter(CurrentValue.Weekday().Contains(thisRow.Name.USA_Weekdaynumber)).First().ToDate()

image
image1898Ă—339 10.3 KB

image
image1922Ă—494 41.9 KB

image
image2046Ă—772 95.1 KB

enjoy, Christiaan

1 Like
3

@Christiaan_Huizer :blush: : Would you mind checking if Anyone with the link is set on Can view :blush: (we can’t access/see your embed at the moment :innocent:)

4

thx @Pch , it is done.
this part of Coda does not feel intuitive yet for me.

image
image1461Ă—276 7.98 KB

5

No problem @Christiaan_Huizer :wink: !

And yes, this step in the sharing process is a bit “too well hidden”, thus, easily forgettable/counter intuitive :innocent: .