worksheet calculation

[delboy1616]

I am trying to create a calculation of hours worked within a month, but not a straight calendar month, on this worksheet. All formulas with the exception of col "J" appears to be working fine.

I have the Daily hours calculated in col "I". My thoughts were to use col "I" data and intergrate into my monthly Hours. I need to colate the data according to the dates in col's "R,S,T". Once this is set up I wont need to make any changes until 2018, whereby the 2018 dates can be edited.

As the daily jobs quanitity changes from day to day, my monthly total has to be flexible to appear on the first working day of the monthly capture period i.e. December 3/12/16. Now as there is no work on a weekend the first working day would be the 5th or the first entry for that time period. In my example sheet it would be in cell "J5"
Thanks...

 

[vletm]

Would You test a formula to Cell[U8) like
=SUMIFS(H:H;G:G;">="&S8;G:G;"<="&T8)
and copy it down as needed.
If ';' would make a challenge then change those to ','.

 

[delboy1616]

Vietm, that appears to be working as designed. Thank You for your help today.