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