Hello one and all.
I need help please on a date function, I am using Excel 2007 and Column B is full of dates like 03/08/2011 Etc.
I need some code to populate Column Q the week numbers corresponding to the Dates in column B IE 32 (Week 32), I have used this code but the result is not always correct.
TRUNC(((StartDate-DATE(YEAR(StartDate),1,0))+6)/7)
I need help please on a date function, I am using Excel 2007 and Column B is full of dates like 03/08/2011 Etc.
I need some code to populate Column Q the week numbers corresponding to the Dates in column B IE 32 (Week 32), I have used this code but the result is not always correct.
TRUNC(((StartDate-DATE(YEAR(StartDate),1,0))+6)/7)
