Week numbers are a bit tricky as they can span years and also that the week numbers aren't calculated the same across different countries.
So for instance in India week #1 of 2016 starts on the 27th of December of 2015 and ends on the 2nd of January 2016 whereas in the UK week#1 of 2016 starts on the 4th of January 2016 and ends on the 10th of January 2016.
However you can use the Week() function will always return a number between 1 and 52 or 53 (depending on country settings). WeekYear() function will indicate which year the week belongs to.
Basically this is what you have to do:
Dual( Month(Date) & 'W' & Week(Date) , WeekYear(Date) & Week(Date) )
Thanks For Your Time.
Its working Fine.Showing week trend but where i need to change if client Doesn't want Continuous week Numbers.
Required OutPut:anw1,janw2,janw3,janw4,Janw5, Febw1,FebW2,febW3,Febw4,Marw1,narw2,Marw3....
Please find attached Current Output Format.
Week Trend.png 34.9 K
Weeks are not divisible into months. You will most of the time have a week at the beginning and the end of the month that will not be seven days. Comparing the sales numbers for a week containing fewer than seven days with those that have seven days would not be very correct would it? How would you want to resolve that?