Calculating the last day of the week

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
 
G

gmunro

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

Bob Phillips

=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

Last day of week 5
My ref: RN0001 Find the first & last occurrence of a strings 5
Day of Week 2
Fiscal Year Week Number Calculation with a twist.... 6
Day of Week from dd/mm/yyyy 7
Spam 4
Date Range of Week 9
Formula to tell day of week 2

Top