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

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?
 
I

ibeetb

By the way, as another example: If today is Tuesday, I need to calulate the
date of the last Saturday......
 
C

Chip Pearson

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 [email protected]
 
D

Daniel.M

ibeetb,

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

Regards,

Daniel M.
 
Top