week numbers

[dympna]

Hi could any one assist me, I have created an excel sheet as a tracker
to highlight tasks that need to be completed before the start date of
a project.
I have input the week number manuall and it is not based on a date or
anything like that.
I am finding that at the end of this year for week 52 it is continuing
to roll onto week 53 and does not recognise that my max for the week
number or for this figure is 52 and then I want it to start at 1 again
for the next year.

Can you advise if I have to insert the correct monday date of that
week so that excel can to a proper count.

I would appreciate any help you can give me.

 

[Sandy Mann]

I have input the week number manuall and it is not based on a date or
anything like that.
I am finding that at the end of this year for week 52 it is continuing
to roll onto week 53 and does not recognise that my max for the week
number or for this figure is 52 and then I want it to start at 1 again
for the next year.

Assuming that you are entering the first week number manually and you are
using the formula =A1+1 to index the week number change your formula to:

=IF(A1+1=53,1,A1+1)

which will reset the count back to 1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

You can use the MOD function
=MOD(A1,52)

Assuming that you are entering the first week number manually and you are
using the formula =A1+1 to index the week number change your formula to:

=IF(A1+1=53,1,A1+1)

which will reset the count back to 1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sandy Mann]

Not quite you end up with a zero at after 51. Slight modification:

=MOD(A1,52)+1

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk