How can I find the first Friday of a month?

1

How can I find the first Friday of a month?

1 Like
2

I figured it out -

thisRow.[First Day]-Day(thisRow.[First Day])+8-Weekday(thisRow.[First Day]-Day(thisRow.[First Day])+2)

1 Like
3

Hey craig!
This was a fun brain teaser to try myself, I want to share my alternative solution :slight_smile:

[First Day] + Remainder(5 - [First Day].Weekday(), 7)