Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Entry to calculate remaining inventory | Excel Discussion (Misc queries) | |||
How to calculate portfolio returns over different periods of time | Excel Worksheet Functions | |||
calculate time periods | Excel Worksheet Functions | |||
How do I calculate rate when pmt is made at end of periods | Excel Worksheet Functions | |||
Calculate Remaining Balance | Excel Worksheet Functions |