yeah changing it from 8 to 7 does work either it seems that datediff is working on the assumption that the week starts on the sunday as if i enter Sundays date 05.04.2020 it appears in the weekly count. but last week tuesday to today only counts the sunday within the week total?