automatic calculate at specific month

L

Lowan Chan

Hi,

Can anyone help me to make a formula which can automatically calculate a
retire fund:

a staff join company on April 20, 2010, salary $15,000, I need to calculate
his retire fund on the third month, which is June 30. So on June 30, the
total retire fund on June 30 that company needs to pay should be: 275+750+750
April: 15,000/30*11days*5%=275
May: 15000*5%=750
Jun: 15000*5%=750
but July 31 onward, it will back to normal salary * 5%
assume that the salary paid in April - July is in cell A1, B1,C1, D1, and
retire fund for each month is in cell A2, B2, C2, D2.

thanks a lot!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the Number of Weekdays by Month 3
Formula to fill cells based on Date of Arrival and Date of Departure 1
Multi NetWorkDays Calculation 3
How do I calculate time in excel (clock in and clock out 3
12 Month Rolling Sum 2
Date Comparison Formula 4
VBA to insert date string 2
Dates - Need to display date one month prior to user-entered date 13

Top