Split a Month into Weeks with respect to Work Days

Help Studio
, ,
1

Hello,

I am struggling to figure out a suitable solution for the below scenario:

Weeks
Weeks549×932 215 KB

I have the white tables in a DataTable. I need to find out each week (W-1, W-2…) with their date range.
• Every week ends in Friday
• The last week ends in the last day of the month
• Week will start from the first day of the month
• If the first day of the month is Friday, start from the second day of the month

◘ Also a work day(without Friday) count for each of the week

I can get the dates which are Fridays, but still trying to find a way to put them.

Thanks in advance

2

Hey!

Try this:

Regards,
NaNi