G
Guest
Hi,
I am using below dates and convert them to
year and week using a formula that looks like this
=YEAR(A1)&"/"&WEEKNUM(A1)
5/7/2007 0:00 2007/19
1/9/2007 0:00 2007/2
5/15/2007 0:00 2007/20
The combined year and week is then base for a pivot tabel
where I sort the columns by the "Year/week".
The problem is that week 2 is sorted after week 19.
Is there some way to get the "year/week" to look like this
2007/02 when the week is 1-9?
The reason why I can not sort only by week is that I have dates
from different year. Sorting by week then mix up data from
year 2006 week 2 and year 2007 week 2.
Is there some smart person out there who can help me with
this problem
?
Patric
I am using below dates and convert them to
year and week using a formula that looks like this
=YEAR(A1)&"/"&WEEKNUM(A1)
5/7/2007 0:00 2007/19
1/9/2007 0:00 2007/2
5/15/2007 0:00 2007/20
The combined year and week is then base for a pivot tabel
where I sort the columns by the "Year/week".
The problem is that week 2 is sorted after week 19.
Is there some way to get the "year/week" to look like this
2007/02 when the week is 1-9?
The reason why I can not sort only by week is that I have dates
from different year. Sorting by week then mix up data from
year 2006 week 2 and year 2007 week 2.
Is there some smart person out there who can help me with
this problem
?Patric