Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
week numbers
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
week numbers
wrote in message
ups.com... 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 with @tiscali.co.uk |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
week numbers
You can use the MOD function
=MOD(A1,52) "Sandy Mann" wrote: wrote in message ups.com... 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 with @tiscali.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving week numbers | Excel Worksheet Functions | |||
I need to =a set of numbers to a given week day.ie 6031 = Wed ect | Excel Discussion (Misc queries) | |||
Calendar Template with week numbers | Excel Discussion (Misc queries) | |||
Week Numbers | Excel Discussion (Misc queries) | |||
How do I use week numbers for sub-totalling? | Excel Discussion (Misc queries) |