Calculating the last day of the week

  • Thread starter Thread starter Job
  • Start date Start date
J

Job

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
 
If you have a date in date format in cell A1, in cell A2, put
=A1+6
Did I misunderstand you?
 
=A1+(7-WEEKDAY(A1))

--

HTH

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