Days money is invested

[Ranbir]

Dear Friends,

I am attaching a sample sheet, where i want to calculate the number of days money is investested.

the assumption is

at the start of a month the branch has some cash in hand

then we send them money, they procure the material and give us the Bill of Lading (B/L)
the cost of material for which B/L is received is shown as ourflow.

here we want to calculate the number of days in which money is being rotated after sending the money and receiving the B/L.

you can add a column if you need for the calculation of the same.


Thanks in anticipation.

Regards
Ranbir Singh