Hi

Assuming your date is in cell A1

=A1+7-WEEKDAY(A1)


Will give you the coming saturday

HTH :-)
--

_______________________
Naz,
London


"Michael Ermino" wrote:

I'm trying to figure out a formula that will return the date of the
coming up saturday given the current date. For instance if the
current date is 4/10/2007, I want the formula to return 4/14/2007
which is the next saturday. If the current date is 4/9/2007, I want
the formula to return 4/14/2007.

thanks in advance.