Limiting numberseries?

[marcus7601]

Hi,

Does anyone know if i can limit a numberserie? I want to use normal calculation though.

Example:
752+1=801

I will only use numbers 701-752, 801-852, and so on.

This is for week calculations. (year 2007, week 1)

[Paul]

Well, I'm not sure how your data is laid out, but this might work..

Let's assume your first "week" value is in A1, and you want to add a number of weeks, which you enter in cell B1. In C1 use this formula:

Please Login or Register  to view this content.

Update: This formula fails if you enter a large enough value in B1 so that it spans a second year (say, 751 plus 66 weeks, this will result in 865 instead of going to 9xx). I'm sure the formula could be adjusted to accommodate that, though.

[marcus7601]

Please excuse a newbie, but i only get a formula-error when pasting the formula?