calculate remaining pay periods
 

Hello,

I'm trying to find a formula to calculate the remaining pay-periods of a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!

calculate remaining pay periods
 

It depends on what the pay dates are. 2 a month is usually the 15th and last
day of the month.

You'll have to tell us what the pay dates are.

--
Biff
Microsoft Excel MVP


"maijiuli" wrote in message
...
Hello,

I'm trying to find a formula to calculate the remaining pay-periods of a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a
year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!

calculate remaining pay periods
 

=(12-MONTH(A1))*2+1+(DAY(A1)<16)


"maijiuli" wrote:

Hello,

I'm trying to find a formula to calculate the remaining pay-periods of a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!

calculate remaining pay periods
 

Thank you very much!
--
Thank You!


"Teethless mama" wrote:

=(12-MONTH(A1))*2+1+(DAY(A1)<16)


"maijiuli" wrote:

Hello,

I'm trying to find a formula to calculate the remaining pay-periods of a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!

calculate remaining pay periods
 

You're welcome!

"maijiuli" wrote:

Thank you very much!
--
Thank You!


"Teethless mama" wrote:

=(12-MONTH(A1))*2+1+(DAY(A1)<16)


"maijiuli" wrote:

Hello,

I'm trying to find a formula to calculate the remaining pay-periods of a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!

calculate remaining pay periods
 

calculate the remaining pay-periods of a year.

Curious about this:

If the hire date was 12/31/2008, how many pay periods are remaining in the
year, 1 or 0?

--
Biff
Microsoft Excel MVP


"maijiuli" wrote in message
...
Thank you very much!
--
Thank You!


"Teethless mama" wrote:

=(12-MONTH(A1))*2+1+(DAY(A1)<16)


"maijiuli" wrote:

Hello,

I'm trying to find a formula to calculate the remaining pay-periods of
a
year.

If employee is paid twice a month then they have 24 pay periods a year.

But if they are hired on 2/1/2008 then they only have 22 pay periods a
year.

But if they are hired on 2/16/2008 then they only have 21 pay periods a
year.

Is there a formula to do this?

Thank you,
--
Thank You!