On Mon, 9 Oct 2006 07:34:01 -0700, Ann wrote:

If I have a date in a cell, I need to determine the date of the following
Saturday. For example, if I have the date of 10/8/2006 in a cell, I need the
function to return the date 10/14/2006.

It depends on what you want to do if the date is a Saturday.

If you want the next Saturday, then:

=A1-WEEKDAY(A1+1)+8

Saturday, October 07, 2006 Saturday, October 14, 2006
Sunday, October 08, 2006 Saturday, October 14, 2006
Monday, October 09, 2006 Saturday, October 14, 2006
Tuesday, October 10, 2006 Saturday, October 14, 2006
Wednesday, October 11, 2006 Saturday, October 14, 2006
Thursday, October 12, 2006 Saturday, October 14, 2006
Friday, October 13, 2006 Saturday, October 14, 2006



If you want it to not change, then:

=A1-WEEKDAY(A1)+7

Saturday, October 07, 2006 Saturday, October 07, 2006
Sunday, October 08, 2006 Saturday, October 14, 2006
Monday, October 09, 2006 Saturday, October 14, 2006
Tuesday, October 10, 2006 Saturday, October 14, 2006
Wednesday, October 11, 2006 Saturday, October 14, 2006
Thursday, October 12, 2006 Saturday, October 14, 2006
Friday, October 13, 2006 Saturday, October 14, 2006



--ron