Calculating part amounts

[david gabra]

Hi
I saw a post of a another forum that has a question I need (no answer there) and I am hoping you can answer please.

I want a formula that I can drag down that will calculate the last payment based on last employment date.

I need the formula to used to the correct number of days in a month in the calculation automatically, based on the month of leaving (column B) or Column C

Two formulas needed

Last employment date is: Column C

'number of days in the month to not be paid / divided by total days in month * the monthly wage (column E)

'number of days in the work / divided by the days in the month * monthly wage (column F)

Thanks
David.

Samples results added in excel file.

 

[bosco_yip]

Try,

1] In E2, copied down :

=ROUND((1-DAY(C2)/DAY(EOMONTH(C2,0)))*D2,0)

2] In F2, copied down :

=D2-E2

Regards
Bosco

 

[david gabra]

HI

Please can I have a fomulae for

'number of days in the work / divided by the days in the month * monthly wage (column F) - not just =D2-E2

thanks

 

[bosco_yip]

HI

Please can I have a fomulae for

'number of days in the work / divided by the days in the month * monthly wage (column F) - not just =D2-E2

thanks

In F2, copied down :

=ROUND(DAY(C2)/DAY(EOMONTH(C2,0))*D2,0)

Regards
Bosco

 

[david gabra]

awesome!!!!!!!!!!! - thank you ninja