Hello,
I am looking for a way to determine the date of the first Monday of each month based on the date provided.
For example...
| Date Field | First Monday of the Month |
| 2021-06-11 | 2021-06-07 |
| 2021-05-21 | 2021-05-03 |
| 2021-05-05 | 2021-05-03 |
| 2021-03-13 | 2021-03-01 |
| 2021-01-09 | 2021-01-04 |
The fact that monday comes on different days, and months can have 4 or 5 weeks is throwing me off.
Any ideas?
Thank you all in advance!
