HI PLEASE I NEED SOME EXPERT HELP.........
I HAVE a big problem, and I dont know how to do it..
I need a week number for a given date. For Example my calendar works as follows.
Sometimes the WEEK STARTS on a Saturday, Sometimes The Week begins on a Friday.
Now for example if the Date is Between 7 Jan and 14 Jan 2006 the week number must be 1 (this if if the week starts on a saturday)
If the date is between Feb 4 and Feb 11 2006 the week number must be 5 (also week starts on saturday)
If the date is between Feb 3 and Feb 10 2006 the week number must be 5 (NOW WEEK STARTS ON A FRIDAY)
OR If the date is between March 31 and April 7 2006 the week number must be 13 (NOW WEEK STARTS ON A FRIDAY)
Please how do i calculate the week number depending on what day of the week it starts. MY first week in the Year starts on a Saturday
or Friday. eg. for 2006 the first week must be Jan 6 - Jan 13 and week 52 must be Dec 29 - Jan 5 (Friday)
For 2007 first week will be Jan 5 - Jan 12 is firstweek (friday)
If week starts on Saturday then 2006 first week will be Jan 7 - 14 Jan
and week 52 will be Dec 31 - Jan 7
Thank you VERY MUCH