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)
 

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
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Spam 4
Calculating the last day of the week 3
Display "this week" column headers w/date & day of week? 9
Calculating End Date - Given working 4, 5, 6, or 7 day workweek. 5
count day's 3
validate date entered 3

Back
Top