Calculate Number of Months from Hire Date, Multiply by Number of Days Accrued per Month = Total for Year End

[greenbirdredbeak2015]

Hi Everyone,
I'm looking for a quick formula for this:

Employee Name (A1)
Hire Date (B1)
No. of Days Accrued Per Month (1,1.5,2) (C1)
No. of PTO Days Taken (D1)
No. of PTO Days Available as of 12/31/15 (E1)

Thanks in advance!

 

[sijpie]

something like
=ROUND((12-MONTH(B2)+(31-DAY(B2))/30.5)*C2,0)