=A1+(6-WEEKDAY(A1))

gets the Friday the date in A1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"neowok" wrote in
message ...

hmmm i think that would work better. how would i get the date of the
friday in that week? because i would need those dates anyway as the
axis labels.


--
neowok
------------------------------------------------------------------------
neowok's Profile:
http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=505716