Hi Niek, you can simplify that to

=A1+7-WEEKDAY(A1+2,3)

"Niek Otten" wrote:

Or, if A1 can be a Saturday as well,

=A1+IF(WEEKDAY(A1)=7,14,7)-WEEKDAY(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ann" wrote in message ...
| 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.