Ann, Niek answered your question in worksheet functions, no need to post to
more than one group, if this will not work post back to the same post as you
started, easier to keep track of that way

From worksheet functions newsgroup
=A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ann" wrote in message
...
I need to determine the following Saturday based on a given date in a cell.
For example, in one cell I have a date of 10/8/2006 - I need a function to
return the date of 10/14/2006.