Need to Calculate Inventory Holding Days between to First of Month / End of Month

Hello,

Attached is a spreadsheet ("New - Head Calculator) in where we're trying to figure out a formula that will calculate how many days we held cattle on our ranch during months we managed the cattle. We need to do this by different cattle lot's. The spreadsheet i'd like participates to build on is the "New - Head Day Calculator".

The spreadsheet we currently use is the attached file, "Old- Feedlot Head day Tracking" This spreadsheet let's us pull in & out data from a table inside the sheet to compile how long cattle have been on hand. Works fine but would like to simplify.

Taking a look at the "New - Head Day Calculator" Is it possible to return the same info by utilizing the in & out dates by lot without the use of all the tables in our old sheet.

Thanks in advance for the help.

-Manny

With several helpcolumns and pivot table I came to this result.

Although those value don't match the manualy counted days.

Som van day / month Kolomlabels
Rijlabels Harris1 Harris2 Endtotaal
01 277 341 618
02 -180 171 -9
03 -76 -10 -86
04 334 -23 311
Endtotal 355 479 834

See the attached file.