View Single Post
  #1   Report Post  
Old September 15th 15, 09:38 PM
tomtic56 tomtic56 is offline
Junior Member
 
First recorded activity by ExcelBanter: Sep 2015
Posts: 2
Default nested if function

Hi all, I have a spreadsheet and am trying to calculate hours worked using 2 sheets.
sheet1 is entitlement calculation and sheet2 is public holidays

starting in sheet 1 cell b12 hours started is 01-oct-2015 then sum public holidays rage b2:b9 it just sums the holidays after 30-sep-2015 and get the correct answer which is 7 because the range is
Day Date Hours worked
Friday 03/04/2015 3.5
Monday 06/04/2015 0
Monday 04/05/2015 3.5
Monday 28/09/2015 0
Friday 25/12/2015 3.5
Monday 28/12/2015 0
Friday 01/01/2016 3.5
Monday 04/01/2016 0

however the next entry in cell b12 of sheet 1 may be 01-may-2015 in which case the answer would be 10.5 does this need vb code or does anyone know how to do this using a function. any help would be much appreciated