Greetings,

need help on setting up a worksheet, that makes the week end on Friday, and
starts on Saturday.

currently, weeknum only helps with Mondays & Sundays.

eg. 1st Apr (tuesday) -- 5th Apr(saturday) = week 14 (using weeknum(A1,1)

i'm trying to make 1st Apr (tuesday)-- 4th Apr(friday) = week 14, while 5th
Apr(sat) -- 11th Apr(Friday) = week 15.


TIA.