Dear Experts,
I have a data of planning as mentioned below i want to calculate days of each month from start to end date.
Here is my planning chart module and need your assistance in this regard,
I have shown example of desire data in last three columns.
Best Regard,
Kamran Noor
<tbody>
</tbody>
I have a data of planning as mentioned below i want to calculate days of each month from start to end date.
Here is my planning chart module and need your assistance in this regard,
I have shown example of desire data in last three columns.
Best Regard,
Kamran Noor
STYLE | QTY | TGT | DAYS | START DATE | END DATE | JUL-19 | AUG-19 | SEP-19 |
CARGO | 5210 | 500 | 11 | 5-Jul | 18-Jul | 12 | ||
CHINO | 9650 | 700 | 14 | 19-Jul | 5-Aug | 11 | 4 | |
BASIC | 14570 | 600 | 25 | 6-Aug | 4-Sep | 23 | 3 |
<tbody>
</tbody>