I think you might save yourself a lot of grief by adding a formula field to your object:Day_Before__c as “Week_End__C - 1”
