formula for finding Friday
Just another option:
=A1+MOD(138612,WEEKDAY(A1)+6)
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"EdStevens" wrote in message
oups.com...
Looping through a series of cells with dates, need to compute from the
given date the date of the following Friday. If the given date *is*
Friday, I need that date returned, not the date of the Friday of the
following week.
Thanks.
|