Thanks Bob, this works. Or =A1+7-WEEKDAY(A1)


Cheers

"Bob Phillips" wrote in message
...
=A1+(7-WEEKDAY(A1))

--

HTH

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


"Job" wrote in message
...
Anyone know how to calculate the last day of a 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