Using a col of Dates by day I want to determine a wk ending date.
 

Using a column of Dates by day I want to determine a wk ending date (sat
date) for each date, based on comparing that date to a range of dates that
are Sun thru Sat.

=A1+7-WEEKDAY(A1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Using a column of Dates by day I want to determine a wk
ending date (sat
date) for each date, based on comparing that date to a
range of dates that
are Sun thru Sat.

.

Assume the dates start in A1,

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

copy down as long as needed


--

Regards,

Peo Sjoblom

"Ken Espo" <Ken wrote in message
...
Using a column of Dates by day I want to determine a wk ending date (sat
date) for each date, based on comparing that date to a range of dates that
are Sun thru Sat.

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

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