View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
terryc[_2_] terryc[_2_] is offline
external usenet poster
 
Posts: 20
Default Function to recognize 1st of month?

Employee benefit period is 6/1-5/31. An employee pays 20% of our cost for
medical insurance. Since there may be 2 or 3 paychecks in a month, we divide
the annual cost by 26 paychecks per year.

Is there a function that recognizes 6/1, 7/1 etc so I could calculate how
many months remain in the benefit year* cost of insurance * 20%? Thanks.