Spreadsheet: 120013d1314911993-how-to-mutliple-rounded-numbers-end-of-hte-month-sample
Sheet: Sheet1

 | Todays Date | 2011-09-01 00:00:00 |  | Please Change Column D&E to reflect current year and prior year anniversary on January 1.
 | (Enter Last Day of the month) |  |  | Only Edit Columns that are shaded grey. Each month will allow you to manually enter days used along with birthdays vacation days.
 | End of the Month | 2011-08-31 00:00:00 |  | The end of the month cell to the left should be changed for each month to update accurately.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manually enter days used for vacation.
 | Employee Name | Start Date | Prior Date of Hire Anniversary Date | 2011 Date of Hire Anniversary Date | REMAINING DAYS AVAILABLE | # of Days Worked after anniversary | Number of Months Worked after anniversary | Service Credit earned total for the year to date. | Years of Service | Vacation Weeks Available | [NAME] From Previous Year (Manully Enter last years rolled over days.) | 2011 Days Earned | Days Rounded Down | 2012 Earned Days | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | Birthday | Date of Birthday Vacation used | Birthday Payout | Hours x days available
BOSCH-(1340) | a | 2007-01-03 00:00:00 | 2010-01-03 00:00:00 | 2011-01-03 00:00:00 | 8.833333333333334 | 240 | 7 | 0.5833333333333334 | 4 | 2 | -1 | 10 | 10 | 5.833333333333334 |  | 1 |  | 5 |  |  |  |  |  |  |  |  | 2011-04-23 00:00:00 |  | 2011-07-29 00:00:00
 | b | 2008-07-18 00:00:00 | 2010-07-18 00:00:00 | 2011-07-18 00:00:00 | 1.833333333333334 | 44 | 1 | 0.08333333333333333 | 3 | 2 | 0 | 10 | 10 | 0.8333333333333333 |  | 5 | 1 |  |  |  | 3 |  |  |  |  |  | 2011-10-01 00:00:00
 | c | 2006-06-12 00:00:00 | 2010-06-12 00:00:00 | 2011-06-12 00:00:00 | 17.5 | 80 | 2 | 0.1666666666666667 | 5 | 3 | 11 | 15 | 15 | 2.5 |  | 2 |  | 2 | 5 | 1 |  | 1 |  |  |  |  | 8/18
 | d | 2001-09-09 00:00:00 | 2010-09-09 00:00:00 | 2011-09-09 00:00:00 | 15 | 0 | 0 | 0 | 9 | 3 | 5 | 14.63045765386639 | 14 | 0 |  | 1 |  | 3 |  |  |  |  |  |  |  |  | 7/16 |  | 2011-07-29 00:00:00
 | e | 2000-07-30 00:00:00 | 2010-07-30 00:00:00 | 2011-07-30 00:00:00 | 3.25 | 32 | 1 | 0.08333333333333333 | 11 | 3 | 6 | 15 | 15 | 1.25 |  | 2 | 11 | 1 | 2 |  | 3 |  |  |  |  |  | 12/19
 | f | 2000-07-30 00:00:00 | 2010-07-30 00:00:00 | 2011-07-30 00:00:00 | 11.25 | 32 | 1 | 0.08333333333333333 | 11 | 3 | 4 | 15 | 15 | 1.25 |  | 1 |  | 3 | 5 |  |  |  |  |  |  |  | 7/23 | 2011-07-22 00:00:00
 | g | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 2011-09-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-03 00:00:00 | 2011-05-03 00:00:00
 | h | 2005-09-12 00:00:00 | 2010-09-12 00:00:00 | 2011-09-12 00:00:00 | 1 | 0 | 0 | 0 | 5 | 3 | 0 | 14.50716728037875 | 14 | 0 | 1 | 1 | 1 | 3 | 4 |  | 3 |  |  |  |  |  | 2011-06-12 00:00:00 | 2011-06-10 00:00:00
 | i | 2007-01-08 00:00:00 | 2010-01-08 00:00:00 | 2011-01-08 00:00:00 | 10.83333333333334 | 235 | 7 | 0.5833333333333334 | 4 | 2 | 3 | 10 | 10 | 5.833333333333334 | 1 |  |  | 2 |  | 2 | 3 |  |  |  |  |  | 2011-11-30 00:00:00
 | j | 2007-05-14 00:00:00 | 2010-05-14 00:00:00 | 2011-05-14 00:00:00 | 5.5 | 109 | 3 | 0.25 | 4 | 2 | 2 | 10 | 10 | 2.5 |  | 2 |  |  |  | 7 |  |  |  |  |  |  | 2011-06-17 00:00:00 | 2011-06-18 00:00:00 | 2011-07-26 00:00:00
 | k | 2006-09-06 00:00:00 | 2010-09-06 00:00:00 | 2011-09-06 00:00:00 | 7 | 0 | 0 | 0 | 4 | 2 | 0 | 9.835832018236015 | 9 | 0 |  |  |  | 2 |  |  |  |  |  |  |  |  | 2011-01-23 00:00:00 |  | 2011-07-24 00:00:00
 | l | 2003-07-15 00:00:00 | 2010-07-15 00:00:00 | 2011-07-15 00:00:00 | 5.25 | 47 | 1 | 0.08333333333333333 | 8 | 3 | -1 | 15 | 15 | 1.25 |  |  | 1 | 1 | 2 | 5 | 1 |  |  |  |  |  | 2011-01-02 00:00:00 | 2011-01-09 00:00:00
 | m | 2004-05-17 00:00:00 | 2010-05-17 00:00:00 | 2011-05-17 00:00:00 | 4.75 | 106 | 3 | 0.25 | 7 | 3 | 0 | 15 | 15 | 3.75 |  | 3 | 2 | 8 |  |  | 1 |  |  |  |  |  | 2011-02-08 00:00:00 | 2011-02-13 00:00:00
 | n | 2007-12-26 00:00:00 | 2010-12-26 00:00:00 | 2011-12-26 00:00:00 | 4 | 0 | 0 | 0 | 3 | 2 | 2 | 6.794669472207611 | 6 | 0 |  |  |  | 2 |  |  | 2 |  |  |  |  |  | 2011-07-31 00:00:00 | 2011-07-31 00:00:00
 | o | 2009-05-05 00:00:00 | 2010-05-05 00:00:00 | 2011-05-05 00:00:00 | 6.5 | 118 | 3 | 0.25 | 2 | 2 | 0 | 10 | 10 | 2.5 | 1 | 2 |  | 1 |  | 2 |  |  |  |  |  |  | 4/10 | 2011-04-30 00:00:00
 | p | 2001-08-21 00:00:00 | 2010-08-21 00:00:00 | 2011-08-21 00:00:00 | 0 | 10 | 0 | 0 | 10 | 3 | 0 | 15 | 15 | 0 |  |  |  | 2 | 13 |  |  |  |  |  |  |  | 2011-10-09 00:00:00
 | q | 2007-11-20 00:00:00 | 2010-11-20 00:00:00 | 2011-11-20 00:00:00 | -1 | 0 | 0 | 0 | 3 | 2 | 0 | 7.780992460108714 | 7 | 0 |  | 2 |  | 3 | 1 | 2 |  |  |  |  |  |  | 2011-04-06 00:00:00 | 2011-03-29 00:00:00 | 2011-07-28 00:00:00
 | r | 2005-09-14 00:00:00 | 2010-09-14 00:00:00 | 2011-09-14 00:00:00 | 2 | 0 | 0 | 0 | 5 | 3 | 2 | 14.42497369805366 | 14 | 0 | 3 | 1 | 2 |  |  | 2 | 6 |  |  |  |  |  | 2011-11-07 00:00:00
 | s | 2004-09-15 00:00:00 | 2010-09-15 00:00:00 | 2011-09-15 00:00:00 | 9 | 0 | 0 | 0 | 6 | 3 | 5 | 14.38387690689111 | 14 | 0 | 4 | 3 |  | 1 | 1 |  | 1 |  |  |  |  |  | 2011-08-10 00:00:00 | 2011-08-14 00:00:00 | 2011-07-29 00:00:00
 | t | 1997-09-22 00:00:00 | 2010-09-22 00:00:00 | 2011-09-22 00:00:00 | 4 | 0 | 0 | 0 | 13 | 3 | 0 | 14.09619936875329 | 14 | 0 |  |  |  |  |  |  | 10 |  |  |  |  |  | 2011-09-16 00:00:00
 | u | 2007-04-16 00:00:00 | 2010-04-16 00:00:00 | 2011-04-16 00:00:00 | 5.333333333333332 | 137 | 4 | 0.3333333333333333 | 4 | 2 | 0 | 10 | 10 | 3.333333333333333 |  | 1 |  | 2 |  | 2 | 3 |  |  |  |  |  | 2011-10-21 00:00:00
 | v | 2006-09-25 00:00:00 | 2010-09-25 00:00:00 | 2011-09-25 00:00:00 | -5 | 0 | 0 | 0 | 4 | 2 | -1 | 9.315272663510433 | 9 | 0 |  | 5 | 5 |  |  | 1 |  | 2 |  |  |  |  | 2011-09-05 00:00:00
 | x |  |  |  | 0
 |  |  |  |  | 0