=WEEKNUM(A1+1) ?
--
David Biddulph

"tze" wrote in message
...
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.