How can I find the first Friday of a month?

How can I find the first Friday of a month?

1 Like

I figured it out -

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

1 Like

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)

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.