Subtracting Weeks

[squiggy]

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!

[Carim]

Hi,

Take a look at the weeknum() function ...

HTH
Carim

[squiggy]

Hi,

Take a look at the weeknum() function ...

HTH
Carim

Yeh had a look but cant get it right problem is ive no actual dates to link it to only week numbers

[Carim]

If you are dealing with weeks, and
say 52 is in cell b2
and 50 is cell c2

in cell d2, you can type
=B2-C2

to get your result ...

HTH
Carim

[squiggy]

Yeh thats the way i had it set up and its fine until i come to the next year say he joined in week 10 of the previous year and its now week 5 im ending up with minus number.

Id say i probably have you so confused, sorry

[Carim]

Ok ...

Two suggestions :

1. Replace your substraction formula by the following formula, after having adjusted the cells to your case ...

Please Login or Register  to view this content.

2. If this does not work, then upload a zipped copy of your worksheet for a precise answer ...

HTH
Carim