week num

J

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi there i am trying to get excell to do the following

WK 1

for example i want to put the work WK short for week before the week num forumulae so it looks like WK 5 etc
 
Perhaps:
Code: 
[TABLE]
[TR]
[TD]="WK "&WEEKNUM(NOW())&" "&YEAR(NOW())
[/TD]
[/TR]
[/TABLE]
 
Hi thanks for this, the only issue now is that it is shows 31/12/17 as week 53 when infact it is week 52, what do i need to do to alter this.
 
Excels weeknum function can result in a week 54 in some years! This is because:
1. 1st January is always Week 1.
2. But .... there is also a day number for each day of the week (1 to 7). By default, 1 is Sunday, to 7 (Saturday)
So if 1st Jan is Saturday, that would be Week 1, but because day 1 starts a new week 2nd January becomes week 2, so Week 1 is only used on one day!.
If you check out year 2000, 31122000 is Week 54.
I suggest you look on the internet as the problem is well covered there, or you could use a date set of your own.
 
You must log in or register to reply here.
Back
Top