Hi Experts,
Data runs in over 10000K rows with dates in a sheet(Excel 2010)
Need to convert them in a weeks as follows for year 2015 and 2016
01Jan to 07 Jan is week 1
08 Jan to 14 Jan is Week2
15Jan to 22Jan is week3
23Jan to 30Jan is Week4
31Jan to 07 Feb Week 5... up to 24Dec to 31Dec is Week52
Any helpful tips or suggestion for function is appreciated
Karnik
Bookmarks