Hi Myrna,

I know, but if the date is on a Saturday and you always want the next
Saturday it's easy
to change to =A1+7-MOD(WEEKDAY(A1),7)

if A1 holds 02/05/05 then the above will return 02/12/05 and I find it easy
to change

and you can't change =A1+7-WEEKDAY(A1) as easily

--

Regards,

Peo Sjoblom

"Myrna Larson" wrote in message
...
Hi, Peo:

Why MOD(WEEKDAY(A1),8) rather than just WEEKDAY(A1)? For a series of
dates,
Sun thru Sat, they both give the same answer.


On Thu, 3 Feb 2005 12:26:35 -0700, "Peo Sjoblom" wrote:

Assume the dates start in A1,

=A1+7-MOD(WEEKDAY(A1),8)

copy down as long as needed