Find the date of the coming up Saturday given the current date.
Something like this:
=A1+(6-Weekday(A12))
--
Rodrigo Ferreira
"Michael Ermino" escreveu na mensagem
oups.com...
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.
|