如何按照入职天数按比例计算第13薪

How to calculate your 13^th salary according to you hire date

The whole info show in follow table (original is in Excel file):

Already know:

You first on-board/employment day is: 2010-10-15

The end of year: 2010-12-31

Assume your basic month salary is : 5000

The steps to calculate your partly 13^th salary:

The days between your first day to the end of year is:

E3 = DAYS360(A3, B1)

= 76 days

The corresponding months is:

F3 = IF( E3 >=360, 12, (E3 / 30.5) )

= IF(76>=360, 12, 76/30.5)

= IF(76>=360, 12, 2.4918033)

= 2.4918033

In which:

360 means if you hire days already exceed 360 days, take it as the whole year, 12 months.

30.5 means the average days of each month.

Then the actual used number of month is:

G3 = ROUND(F3, 0)

= ROUND(2.491803279, 0)

= 2

So the final percentage is:

B3 = G3 / 12

= 2 /12

= 0.16667

= 17%

Then your partly 13^th salary is:

E3 = C3 * D3

= 17% * 5000

= 833.3