On Fri, 20 Jun 2008 06:29:46 -0700 (PDT), vezerid wrote:

One way: for a date in A2, next Friday:

=CEILING(A2+1,7)-1

HTH
Kostis Vezerides

That only works with the 1900 date system. With the 1904 date system, commonly
used on Mac's, it will not give the correct answer.
--ron