Last day of week

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

Job

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
 
So you want the coming Saturday except if the date is Saturday?

with the date in A1


=A1+7-WEEKDAY(A1)
 
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
Click to expand...

I guess if Sunday is the first day, that Saturday must be the last day of the
week?

=A1+7-WEEKDAY(A1)


--ron
 
see response in programming

--

HTH

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