Confidentjohn
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 73
Hello
I was wondering if someone could help.
I know how to generate the current weeknumber and also the current year.
The trouble I have is the year jump when pulling this down as a dynamic formula.
Basically I need to genereate a list of week numbers with the year. This will update every week as the week changes, How to I write a formula to know that when the weeks number has reached 0 to go back to 52 and minus the year by one.
My current sheet has two columns.
Column A This displays the week number which is set with the following formulas
cell a1
WEEKNUM(NOW())-1
cell a2 onwards
IF(A1-1=0,52,A1-1)
This is working out that if the week number reaches 0 to start again at 52
column B is displaying the year, however I want to be able to move the year to 2010 when the weeks jump over.
Is there an easy way to do this?
Cheers
John
I was wondering if someone could help.
I know how to generate the current weeknumber and also the current year.
The trouble I have is the year jump when pulling this down as a dynamic formula.
Basically I need to genereate a list of week numbers with the year. This will update every week as the week changes, How to I write a formula to know that when the weeks number has reached 0 to go back to 52 and minus the year by one.
My current sheet has two columns.
Column A This displays the week number which is set with the following formulas
cell a1
WEEKNUM(NOW())-1
cell a2 onwards
IF(A1-1=0,52,A1-1)
This is working out that if the week number reaches 0 to start again at 52
column B is displaying the year, however I want to be able to move the year to 2010 when the weeks jump over.
Is there an easy way to do this?
Cheers
John