Spreadsheet: 104638d1302166170-how-to-create-a-subtotal-based-on-date-range-dystop1a_vl_solved
Sheet: Sheet2

 | Employees Name: |  | [NAME]
 | Designation: |  | Accounting Staff
 | Date Hired: | 2007-03-05 00:00:00 |  |  | Balance | VL | SL
 |  | Term 1: | 2007-08-16 00:00:00 | 2008-08-15 00:00:00
 |  | Term 2: | 2008-08-16 00:00:00 | 2009-08-15 00:00:00 |  |  |  |  |  | Your current VL balance as of
 |  | Term 3: | 2009-08-16 00:00:00 | 2010-08-15 00:00:00
 |  | Term 4: | 2010-08-16 00:00:00 | 2011-08-15 00:00:00 |  |  |  |  |  | is
 |  | Term 5: | 2011-08-16 00:00:00 | 2012-08-15 00:00:00
 |  | Term 6: | 2012-08-16 00:00:00 | 2013-08-15 00:00:00
 | DATE | LEAVE | LEAVE | ENTITLEMENT |  | U S E D |  | B A L A N C E |  | R   E   A   S   O   N   /   S
 | FILED | DATE/S | DAY/S | VL | SL | VL | SL | VL | SL
 | 2007-06-12 00:00:00 | 2007-06-04 00:00:00 | 1 |  |  | 1 |  |  |  | First day of School
 |  | 2007-07-06 00:00:00 | 0.5
 |  | 2007-07-09 00:00:00 | 1
 |  | 2007-07-10 00:00:00 | 0.5 |  |  |  | 3 |  |  | Sufferred from [NAME]
 | 2007-07-13 00:00:00 | 2007-06-28 00:00:00 | 1
 | 2008-01-07 00:00:00 | 01/ 03 & 04 | 2 |  |  | 2 |  |  |  | Yearly convention/Sick Father
 | 2008-01-07 00:00:00 | 01/03 & 04 | 2 |  |  | 2 |  |  |  | brother was sick
 | 2008-02-11 00:00:00 | 2008-02-01 00:00:00 | 0.5 |  |  | 0.5 |  |  |  | Pick Up Pagibig Loan
 | 2008-03-17 00:00:00 | 2008-03-19 00:00:00 | 1 |  |  | 1 |  |  |  | Circuit Overseer Visit
 | 2008-04-14 00:00:00 | 2008-03-31 00:00:00 | 1 |  |  | 1 |  |  |  | Recognition day of youngest daughter
 | 2008-04-29 00:00:00 | 2008-04-17 00:00:00 | 0.5 |  |  | 0.5 |  |  |  | Check up of Husband
 | 2008-07-28 00:00:00 | 2008-07-14 00:00:00 | 1 |  |  |  | 1 |  |  | Suffered from Asthma
 | 2008-08-11 00:00:00 | 2008-08-08 00:00:00 | 0.5 |  |  | 0.5
 | 2008-12-11 00:00:00 | 12/09,12/10 | 1.5 |  |  | 1.5
 | 2008-12-22 00:00:00 | 2008-12-12 00:00:00 | 0.5 |  |  | 0.5 |  |  |  | hospitalization of her father
 | 2009-01-13 00:00:00 | 0/05 , 01/07 | 1.5 |  |  | 1.5
 | 2009-01-16 00:00:00 | 2009-01-16 00:00:00 | 1 |  |  | 1 |  |  |  | follow up check up of her daughter
 | 2009-01-28 00:00:00 | 01/14 & 18 | 1.5 |  |  | 1.5
 | 2009-02-10 00:00:00 | 1/26,28-30 | 3.5 |  |  | 3.5 |  |  |  | 1/26- Check up of her daughter, 1/28-30- Burial of his father
 | 2009-02-11 00:00:00 | 2008-02-01 00:00:00 | 0.5 |  |  | 0.5
 | 2009-03-04 00:00:00 | 2009-03-03 00:00:00 | 0.5 |  |  | 1 |  |  |  | Check up of daughter
 | 2009-04-02 00:00:00 | 2009-04-01 00:00:00 | 1 |  |  |  | 1 |  |  | Body pain, dizziness
 | 2009-04-13 00:00:00 | 2009-04-13 00:00:00 | 0.5 |  |  | 0.5 |  |  |  | emergency (husband was in the hospital)
 | 2009-05-27 00:00:00 | 05/26 – 06/10 | 2 |  |  | 1 | 1 |  |  | Suffered from Asthma
 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 1 |  |  | 1 |  |  |  | Check up of my daugther
 | 2009-07-28 00:00:00 | 2009-07-14 00:00:00 | 1 |  |  | 1 |  |  |  | Asthma
 | 2009-12-14 00:00:00 | December 17 & 18 | 2 |  |  | 2 |  |  |  | Annual Assembly Convention
 | 2009-12-23 00:00:00 | 2009-12-16 00:00:00 | 0.5 |  |  |  | 0.5 |  |  | Suffered from Asthma
 | 2010-02-26 00:00:00 | Feb 16-19, 2010 | 4 |  |  |  | 4 |  |  | Suffered from Asthma
 | 2010-03-30 00:00:00 | 2010-03-26 00:00:00 | 1 |  |  | 1 |  |  |  | Recognition day of Daughter
 | 2010-03-30 00:00:00 |  | 0.5 |  |  | 0.5 |  |  |  | To attend death anniversary of [NAME]
 | 2010-06-08 00:00:00 | 2010-06-15 00:00:00 | 1 |  |  | 1 |  |  |  | First day of classes, need to talk to my daughter's teacher regarding DM condition.
 | 2010-08-11 00:00:00 | 2010-07-30 00:00:00 | 1 |  |  | 1 |  |  |  | Laboratory (test) of my daughter
 | 2010-08-26 00:00:00 | 2010-08-13 00:00:00 | 1 |  |  | 1 |  |  |  | Preparation for our circuit assembly
 | 2010-09-27 00:00:00 | Sept. 28, 2010 | 0.5 |  |  | 0.5 |  |  |  | Schedule of my daughter's check-up at PUP
 | 2010-10-27 00:00:00 | 2010-11-05 00:00:00 | 1 |  |  | 1
 | 2011-01-16 00:00:00 | 2011-01-19 00:00:00 | 1 |  |  | 1 |  |  |  | went to my daughter's school