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