Calculating the last day of the week
=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
|