Calculation of days in each month..

[Kamran01]

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

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>

 

[Trevor_S]

I can't agree some of your example calculations, but assuming that "STYLE" is in cell A1, put this in G2 and copy down and across:


=IF(OR($E2 > EOMONTH(G$1,0),$F2 - 1 < G$1),"",MIN($F2,EOMONTH(G$1,0)) - MAX($E2 + 1,G$1))


Minor adjustments might be needed depending on whether you are trying to include or exclude the start and end dates from the count.