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

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

 

[ibeetb]

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

 

[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 (e-mail address removed)

 

[Daniel.M]

ibeetb,

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

Regards,

Daniel M.