Calculate # of Paychecks based on Date of Hire

Please refer to Attached sheet for referance.

I have a business and i run payroll for my employees twice a month (semimonthly).
Date of paycheck will be 16th and 31st.
So if employee was hired on say 7/5/2009 then this employee will have 3 paychecks as of today
(1st paycheck from 7/1/2009 to 7/15/2009
2nd Paycheck from 7/16/2009 to 7/31/2009
3rd Paycheck from 8/1/2009 to 8/15/2009)

i need to know the # of pay checks for each employee computed in Cell C3 to C7.


Let me know if you have any questions.

Thank you for your help..

Riz Momin