How to Fetch the First Friday of each month ?

Hi All,

Need a small help here

I have to fetch a date value where year should be set to default (for eg- for 2019 - year = 2019, for 2020 - year = 2020 and so on) , month should be passed manually by user and date should be the first Friday of every month (which should be taken automatically once we pass the value for month field).

I have created a formula which is giving me the output as last Friday of each month mentioned as below:

date(datetrunc('week',makedate(YEAR(TODAY()),1,0)+(DATEPART('week',TODAY())),'FRIDAY'))

where "1" marked in red is the value for month.

So,1 as in 1st Friday of Jan

      2 as in 2nd Friday of Feb

      3 as in 3rd Friday of Mar

and so on..

Could anyone please guide me with the calculation ?

Thanks in advance for any help,

Sneha