Help in Calculation Salary

Dear friends..........I have a problem in my spreadsheet......I want to calculate the salary of employee

I have three Columns (1) Col. b7 (Date of joining "25.01.2007") (2)Col. C7 (Last working month of the employee "31.12.2008") (3) Col. D7 (Salary "7000")

(1) If a employee Joined the Duty in the mid of a month e.g. 25.01.2007 then salary should be calculate for particular month (25.01.2007 to 31.01.2007 i.e. workout the 7 days of January 2007 (7000*7/31=1580.64, 1581.00) result should be in B11

(2) unfortunately the next year i.e. December 2008 is the last month of that employee then calculate the salary month by month till December 2008.......... result should be in A34

if employee working for Four Years then Leapyear is a factor.......I want a formula which consider leapyear also

please friends help me

Thanks in advance

Here the sample sheet

see the attached file date format was changed in b7 and c7 and used below formula
A11=IF(EOMONTH($B$7,ROWS($A$11:$A11)-1)>EOMONTH($C$7,0),"",EOMONTH($B$7,ROWS($A$11:$A11)-1))

Please Login or Register  to view this content.

B11=IFERROR(MAX(MIN((A11-B$7)+1,DAY(A11),(C$7-B$7)+1,C$7-EOMONTH(A11,-1)),0)*D$7/DAY(A11),"")

Please Login or Register  to view this content.

COPY TOWARDS DOWN
SEE ATTACHED FILE

ok, will you change the date format as dd/mmm/yy (dates in your sheet not recognizing in my system)

b7=25.01.2007
c7=31.12.2008

a11 on wards dates are recognising

see the attached file

Thanks for your feedback

Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied