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!
|