Hello!

I am looking for help creating a forumla that can help calculate monthly wage expenses for multiple employees among multiple departments (assuming a 40 hour work week), including different start and end dates throughout the month.

Fictional example: We have 72 employees that worked during the month of February 2015. Some worked the whole month. Others were hired in in the middle of the month, others may have left the business during the last week of the month. They also work in different departments with different hourly wages.

Is there a formula that can go through an employee roster spreadsheet that includes start/end dates as well as departments and wages, and give a total sum for the wages paid for a specific month (example, 2/1/15 though 2/28/15)?

I consider myself somewhere in the intermediate level of Excel. My gut tells me it's an incredibly complicated forumula that will involve a lot of COUNTIF's, but I don't know if that's right, or if there is an easier way.

Any information is appreciated. I can also try rewording what I'm looking for if anyone is confused.

Thanks!