Here is my current formula, however, its giving me a negative number rather than a positive. The result is giving me how many records were completed last week based on the "completion_date".
Previous Week: Sum(+Year([Completion_date])*53+DatePart("ww",[Completion_date])=Year(Date())*53+DatePart("ww",Date())-1)
Result: -1 and thinking is should be 1
I also need a formula to show me how many records were completed this week. Please help.