View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maijiuli maijiuli is offline
external usenet poster
 
Posts: 56
Default 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!