Ok here is my problem. The formula below Tests Cell A7 and displays the previous Saturday of that week if the Date in the A7 is Ahead of Saturday in that week. Example.
01/01/2013 "Tuesday", it will display 12/29/2012 "Saturday". My problem is with the "NOW()" function I want the formual to Test "NOW()" and if it does not Equal the Given Saturday Date Run the Formula to Display the appropiate Date Requested,

Here is my formula:

=IF(WEEKDAY(A7)=7,NOW(),A7-WEEKDAY(A7,1))


This formula works fine as is, but I want to modify it to Test if "NOW()" is 7 (aka Saturday) and if it is Saturday Leave it alone but if it's not Saturday List Saturday's Date from that week.