Calculating the last day of the week
 

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

Calculating the last day of the week
 

If you have a date in date format in cell A1, in cell A2, put
=A1+6
Did I misunderstand you?

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

Calculating the last day of the week
 

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