If function combined with weekday

[ImPerplexed]

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.

[vlady]

did you tried weekday(now()) to check?

[rcm]

I used today() in b3

Please Login or Register  to view this content.

[ImPerplexed]

@ vlady Thats my problem I'm not sure where to put in the Logic for this equation.

@rcm I tried that and it includes the Saturday but any day past it list the Following Saturday instead of the previous I tried Switching the Value of "B3" to negative and it can't process the result. No error message it just can't process it.

IF(WEEKDAY(B3)=7,0,7-WEEKDAY(B3))-B3

[vlady]

maybe this???

Please Login or Register  to view this content.

[daddylonglegs]

I'm confused with what you want to do? You have a date in A7 (or B3) and you are testing that date, but also NOW() - are you looking at two different dates or is A7 = NOW()?