Calculate the fornula for the last Saturday of the week....

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

I would like to devise a formula to calculate the last saturday of the week
that may have just passed- of any given week....

Any ideas?
 
By the way, as another example: If today is Tuesday, I need to calulate the
date of the last Saturday......
 
What should the formula return if the give date is a Saturday? The
same day, or one week earlier?

For one week earlier, use
=A1-WEEKDAY(A1)

For the same day, use
=A1-WEEKDAY(A1)+7*(WEEKDAY(A1)=7)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
ibeetb,

Also, for the same day (so finding current/previous Saturday):
=A1-WEEKDAY(A1+1)+1

Regards,

Daniel M.
 
You must log in or register to reply here.

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

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Testing a cell value for a specific weekday. 3
Re: How can I count the number of SATURDAYS in a month? 0
Networkdays including Saturday? 5
Help finding the date of the last Saturday of a given month 9
Calculating number of weeks between dates? 2
need qualifier statement 10
Calculating how many Saturdays there are between two given dates 6

Back
Top