Progression salary

Microsoft Excel 2007
October 8, 2009 at 08:15:47
Specs: Excel 2007
im trying to make a formula that al my employees get a .20 cts raised every 6 months, since they started example
06/01/09 i know that he will get a raised on 12/01/09 but how i will make a formula to help me with this and put all my pay periods and see who is elegible

thank you

See More: Progression salary

Report •

October 8, 2009 at 08:42:56
I don't know the layout of your spreadsheet, but maybe this will get you started:

With 06/01/09 in A1 this will return 12/01/09:


You could wrap other functions around EDATE() to get the results you want.

Report •

October 8, 2009 at 09:55:43
thank you for your quick answer and see i will have in column a the start hiring date and then i will input all the payroll date that is every 2 weeks is it a formula that will help me to find out who will earn the progression salary example
a1 b1 c1 g1
06/01/09 06/15/09 ....... 12/01/09
12.00 12.00 12.00 12.25

Report •

October 8, 2009 at 10:46:15

So here are my assumptions:

1 - The pay dates are on the 1st and 15th of each month.

2 - The six month anniversary date is always on the 1st or 15th of a month, based on the first pay date for that employee.

3 - The first pay date is A1.

4 - The first pay amount is in A2.

5 - The pay increase is .25 not .20 like you said in the OP.

If all that is correct, put this in B2 and drag it across under your pay dates.


Report •

Related Solutions

October 8, 2009 at 11:31:16

Here is another solution for you to look at:

Employee Names in column B starting at B6
Employee Start dates in column C starting at C6

Cell D3 - next pay date
Cell E3 - cts increment per 6 months

The number of completed 6 months is calculated in column D and
The total increment due for each employee is calculated in column E

The calculations in columns D and E can be combined, but for clarity and to check that the formulas work, I kept each step separate.

In D6 the number of months is calculated by the formula
This uses the poorly documented DATEDIF function which, using "m", returns the number of completed months between two dates, in this case the employees start date and the pay date. INT returns the integer part of the division of months employed / 6

E6 is =D6*$E$3/100 to multiply number of completed 6 month periods x rate

Note the $ signs
Drag the two formulas down for each employee

	B	C		D		E
2				Pay date	Rate
3				08-Oct-09	20
5	Name	Start date	# 6 months	Increment
6	Anne	1-Feb-05	9		1.80
7	Zoe	2-Mar-04	11		2.20
8	Bill	3-Apr-03	13		2.60
9	Arthur	09-Oct-03	11		2.20
10	Wendy	07-Oct-03	12		2.40
11	Joe	02-Jun-09	0		0.00
12	Tim	01-Apr-09	1		0.20


Report •

Ask Question