Sub rajreddy()
and press <Enter>= SUMIFS( priorData, end,">"&interval, overnight?,1)
+ SUMIFS( currentData, start, "<="&interval, end,">"&interval, overnight?,0)
+ SUMIFS( currentData, start, "<="&interval, overnight?,1)
= SIGN(end<start)
= INDEX(data,,1+MOD(dayIdx,7))
= INDEX(data,,1+MOD(dayIdx-1,7))