title: Time off tracking tool - Creating a cell value that increments by a designated amount on specific days of the year
body: <p>I am using MS Excel 2007 and I am creating a worksheet that will help employees track Paid Time Off (PTO).  The number of hours an employee has available to use increments by a specific amount of hours twice a month on specific days.  Specifically the 2nd and the 17th of each month.
  I have put the number of hours to add each pay period in one cell lets say A1, I put the =today() function in another cell lets say B1, and the total number of hours available in yet another cell lets say C1.
  I would like the value in the total hours avail cell(C1) to increment by the number that I specified in cell A1 each 2nd and each 17th of each month when the =today() cell reaches that particular month and day.  For example:</p>
  
  <p>An employee gets 5 hours of PTO each pay period.  Pay periods end on the 2nd and the 17th of each month.
  Lets say that todays date is March 2nd 2011. The calculation would need to total all the hours accrued on each pay period from the begining of the year, Jan 1, 2011 to the present day.
  The total for march 2nd would equal 25.  On Mach 17th, the number would increment by 5 (the value in A1) and the total would be 30.  This would continue to the end of the year.</p>
  
  <p>I hope this make sense - I'm not really a programmer type of person.</p>