WeekStart of a week in a month

[TomBond77]

Hi experts

I have the following formula:

networkdays(Floor(WeekStart(min(Date))), floor(WeekEnd(max(Date))))

August 2023 starts with week 31. The last day of July 2023 also is assigned to week 31.

The 31st of July would be WeekStart(min(Date)) of week 31 in the above formula. 

I need to get the very first day of a week in a month with the result only calculating the days in a month but on a weekly basis.

Any ideas? Thank you!

[Or]

Use WeekStart(), check if the day in question belongs to the current month based on whatever logic you're using for that, and if not, add seven days, I guess?

Trying to match up weeks and months is usually frustrating. I'd suggest doing your best to steer away from it if at all possible.