| id | workings_days(day of the week) |
|---|---|
| 1 | "1,5" |
| 2 | "2,3" |
output will be
| id | workings_days(day of the week) |
|---|---|
| 1 | 1 |
| 1 | 5 |
| 2 | 2 |
| 2 | 3 |
and then find close next date from current date according to working days
for example :
if working days 1(means monday) , 5(means friday)
and current day is 3 (means wednesday)
then nxt close day is 5 means friday