I’m really struggling with this, I’ve looked at other threads but haven’t really found anything that helps.
If I had a list of dates for example.
2023-08-01
2023-08-03
2023-08-12
2023-08-13
2023-08-15
2023-08-23
2023-08-28
2023-08-31
How can I check each date to see whether the date is within week1, week2, week3, week4 or week5 of the current month, where the first day of a week is a monday, and the last day of a week is a sunday?
If the first day of the week is not a monday, for example the first week of the month it could be a tuesday, it should treat tuesday as the first day of the week just for that week.
Expected output
2023-08-01 – first week
2023-08-03 – first week
2023-08-12 – second week
2023-08-13 – third week
2023-08-15 – third week
2023-08-23 – fourth week
2023-08-28 – fifth week
2023-08-31 – fifth week