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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating calendar days and completion dates. 4
Last day of week 5
My ref: RN0001 Find the first & last occurrence of a strings 5
Spam 4
Last day of month is saturday or sunday? 2
Workload spreadsheet - pivot tables 4
Day of Week 2
Date question 4

Back
Top