Is the formula correct what to do further
First of all, pat yourself on the back. You're formula is perfect. The issue you are having is that you are using a subsidiary view in your module. Double check that the module AND the line item are both set to "weeks". That should fix your issue.