I need help producing a report that shows number of days within a certain date range

[crazyem91]

Hi All,

I am currently writing a report to show the absence per month by employees, for 1200 employees! So ther report is by month, for june, july, august and september.

Some of the employees have absences longer than a month e.g 14/04/2012 - 27/07/2012. This creates a problem as the total days that it shows aren't correct, as it will show the total - not just for June.

Does anyone have a formula or a theory as to how I can work this, without doing it manually??

I have attached the spreadsheet for you to look at. If you can help, it would be amazing!! and save me so much time.

Thanks,

Emily