Last day of week
 

Anyone know how to calculate the last day of the calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.

Cheers,

Job

=A1+7-WEEKDAY(A1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Anyone know how to calculate the last day of the
calendar week? Assuming
that you have a date in A1, I need to calculate the last
day of the week
(Sunday is first day), for the week that contains the
date in A1.

Cheers,

Job


.

Perfect! Thanks Jason.


"Jason Morin" wrote in message
...
=A1+7-WEEKDAY(A1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Anyone know how to calculate the last day of the
calendar week? Assuming
that you have a date in A1, I need to calculate the last
day of the week
(Sunday is first day), for the week that contains the
date in A1.

Cheers,

Job


.

So you want the coming Saturday except if the date is Saturday?

with the date in A1


=A1+7-WEEKDAY(A1)


--

Regards,

Peo Sjoblom



"Job" wrote in message
...
Anyone know how to calculate the last day of the calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.

Cheers,

Job

On Wed, 9 Mar 2005 08:51:11 -0700, "Job" wrote:

Anyone know how to calculate the last day of the calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.

Cheers,

Job


I guess if Sunday is the first day, that Saturday must be the last day of the
week?

=A1+7-WEEKDAY(A1)


--ron

see response in programming

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Job" wrote in message
...
Anyone know how to calculate the last day of the calendar week? Assuming
that you have a date in A1, I need to calculate the last day of the week
(Sunday is first day), for the week that contains the date in A1.

Cheers,

Job