How to find the first weekday date of a month

[Manish]

Hi 

I have a requirement where I would like to find the first weekday date of a month. in a variable,

for example , If 1st Jan is Sat and 2nd Jan is Sun then in a variable I should get 3rd Jan as an output.

Please let me know how this can be done.

[Clement15]

Hello,

I think something like this might work :

if(month(WeekStart(MonthStart([Date])))=month([Date]),WeekStart(MonthStart([Date])),WeekStart(MonthStart([Date])+7))