Formula to calculate days in month Item is Held

Originally Posted by Phuocam

Try this in F5:

=SUMPRODUCT(--(TEXT(ROW(INDIRECT($C5&":"&$D5)),"mmm")=LEFT(F$3,3)))

The above formula is Volatile... we can rewrite it as below to make it non-Volatile.

=SUMPRODUCT(--(TEXT(ROW(INDEX(A:A,$C5):INDEX(A:A,$D5)),"mmm")=LEFT(F$3,3)))