And depending on what should happen to the Saturday following that Friday:
=A1+6-MOD(A1,7)



Bob Phillips wrote:

=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


--

Dave Peterson

thanks for replies.

i think i have a solution that works now using a few dummy columns with
various formulas in to reduce it down to the required data for the
graph.


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