Formula to display end of week

[Weasel]

What I'm trying to do is find a formula that will display the end of the week (i.e. Saturday) based on a number I enter in cell A1. So for example, if I enter 9/29/08 into cell A1 then I would want the formula to give me a value of 10/4/08 since that is the end of the week. If I enter 9/30/08 the formula would give me the same value of 10/4/08 since that would still be the end of the week. Thanks in advance for any help.

[shg]

=a1 + 7 - weekday(a1)

[Weasel]

Thanks for your help