Just wondering if anybody can help me, Im setting up an excel worksheet that will contain subscription details all based on week numbers.

Basically I need something to tell me how many weeks are left in a subcription, e.g. joined week 52, current week is week 50, and how many weeks are left.

I had worked out a formula but like in the example im ending up with minus numbers so i need to basically tell excel that its weeks im subracting.

I hope you can understand that!