• I agree make sure you are using SET DATEFIRST to set the first day. However if you still have troubles then consider creating a sliding process to slide the dates back the number of days to bring in line for the calculation only.