Network Days, IF statements, Updates

Good afternoon, I'm hoping you can help.

I have started creating a staffing salary sheet however I have become stuck on part of the project and I'm not sure if EXCEL is capable of carrying out this function.

I have attached the sheet and hopefully the explaination of what I'm attempting to achieve is clear.

When a start date is entered and end date is entered, the sheet will calculate what the monthly salary should be between the months. I have managed to this this accross the year Apr 2013 to March 2014, however when the dates entered are between March 2013 and June 2013 the calculation fails.

Ultimately what I would like to happen is when you enter the start date and end date (eg: between 17th March 2013 and 3rd June 2013), the sheet calculates the salary for those months and every else should be £0.00.

Apologies if this is not clear enough. I have included an attachment in the hope what I have said become clear.

Cell G11 = Start date of employee - Cell H11 = End date of employee

Cell W11 = Total Salary

Cells Z11 to AK11 = Months Apr 2013 to Mar 2014

Many thanks for your help everyone.

Regards.

Hello and many thanks for replying so quickly!!!!

W11 always show just the amount payable for the period entered.

Regards.

Good afternoon DILIPandey.

Please ignore some of the formula's in cells, I was trying different formulas to come to a solution. Please see example attached of what I'm trying to achieve (cells Z11 to AK11 and Z12 to AK12).

Many thanks.

Regards.

Hello Daddylonglegs.

Thank you very much for your help.

The formula has worked and I am now able to continue with the project. This has inspired me to work harder on my EXCEL skills and expand my knowledge.

Brilliant!!!!!!!