We have a four week work rota cycle. So week 1, people do x, week 2 the same do y, week 3, z, 4 something else, then it all goes back to 1 and starts again.
I can get excel to work out the week number in the calendar year (ie week 1-52) withbut don't know how to convert that into week 1,2,3 or 4 of our cycle.TRUNC(((StartDate-DATE(YEAR(StartDate),1,0))+6)/7)
By the way, Week 1 of the year, starting 03 Jan was week 3 of our cycle.
Any ideas?
Bookmarks