Show the date of the next Saturday

[polska2180]

Hello I'm looking for a formula that will give me the next closest Saturday. So today is 7/15/11, I would like the date is A1 showing 7/16/11. Once Sunday hits or 7/17/11 the date would than show 7/23/11. Hope this makes sense, thanks.

 

[Dan Waterloo]

=a2+6-mod(a2+6, 7)

 

[polska2180]

=a2+6-mod(a2+6, 7)

thanks...