balars_2000 (6/9/2009)
hi matethanks for ur response; appreciate it.
sorry if i wasnt clear, i need week numbers and week start dates for any given date range or a year. if it was a year, for example 2009, the output would be
week # week start date
1 05/01
2 12/01
3 19/01
and so on till current date. if it was for a date range for example between 19/01 and 2/02 (for 2009) then it should be
week # week start date
1 19/01
2 26/01
3 02/02
thanks again for ur time 🙂
What do you want if data is missing for a whole week during the year?
--Jeff Moden
Change is inevitable... Change for the better is not.