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