Last day of week

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
 
P

Peo Sjoblom

So you want the coming Saturday except if the date is Saturday?

with the date in A1


=A1+7-WEEKDAY(A1)
 
R

Ron Rosenfeld

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
 
B

Bob Phillips

see response in programming

--

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

Formula to tell day of week 2
Calculating the last day of the week 3
Display "this week" column headers w/date & day of week? 9
Spam 4
validate date entered 3
Testing a cell value for a specific weekday. 3
Re: How can I count the number of SATURDAYS in a month? 0
Finding the next dayof the week after a certain date. 4

Top