Count of Days per month for a contract period

Hi All -

I have a list of employees and their billing period against each contract.
I need to calculate the days billed for each employee against each contract by month for last 12 months.
My worksheet and My expected result is mentioned in the attachment.

Thanks for your support.

Regards,
SSP

Firstly attaching a workbook makes life much easier as things don't need to be retyped and having dates for the months to perform the calculation on

=if(and(startdate <= eomonth(monthdate,0),enddate>=monthdate), min(enddate,eomonth(monthdate,0))-max(startdate,monthdate)+1,"no")


is along the line you want so if in H1 you put the date 1-feb-20


and the first row of data was 3
in h3

=if(and(e3 <= eomonth(H1,0),f3>=H1), min(f3,eomonth(H1,0))-max(e3,H1)+1,"no")


tou may need to swap, for ; depending on your locale

Hi Shareez- Thanks for your support. I found some anomalies with the formula especially if the start date is in 2020 and end date is in 2020 or 2021.
row numbers 7,31,36,38,43 have this issue.
Could you please look into it?
Additionally- how do I attach the file while I reply?

Regards,
SSP

follow the instructions in the yellow banner. thee is a go advanced button at the bottom right of the box I am typing in now, click on it. Scroll down to additional options and click on manage attachments. click browse, select the file and upload. then submit in the usual way

Hi -

Thanks for your reply. I have attached my excel file here for your review.

Regards,
SSP

I would do as the attached but differ by 1 for some calculations as it depends how you treat the end date

for example 30Jan-1st Feb you have 2 days in Jan and none in Feb is this true? Did they not work the 1st of Feb