farrukhhameed786 (8/29/2013)
I have attached a workbook to have a Idea how I need it.
So... according to that partial spreadsheet (week 1 is missing a label as is the last week of 2013 so I have to make a guess), the following rules are what you want to follow...
1. Weeks always start on Thursdays.
2. The year that Wednesday falls in determines the year for that entire week.
Is that correct?
--Jeff Moden
Change is inevitable... Change for the better is not.