Subsequent Saturday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Yes, it's me again but with a Slightly different scenario:

In cell C25 = 6/5/2004
Cell C26 = 6/5/2004 - 61 (days)

But, I want the day to only fall on a Saturday (or a Tuesday as the case may be).
I tried using one of the formulas generously suggested yesterday, but the result (while falling on a Tuesday) turned out to be only a differnce of 56 days. The answer needs to be 61 days or more (not less) but still fall on a given day (in this case, a Saturday).

Here's the formula I used:
=C25-61+(7-WEEKDAY(C25-61))+IF(WEEKDAY(C25-61)>61,7,0)
and the answer returned was 4/10/04. However, as I said 6/5/04-4/10/04=56 days.

Please tell me what to change so that the answer will be >= 61 days and fall on a Saturday.

As always...thank you.
 
Try this formula:

C25-61-7+WEEKDAY(C25+61)

See if this works.
-----Original Message-----
Yes, it's me again but with a Slightly different scenario:

In cell C25 = 6/5/2004
Cell C26 = 6/5/2004 - 61 (days)

But, I want the day to only fall on a Saturday (or a Tuesday as the case may be).
I tried using one of the formulas generously suggested
Click to expand...
yesterday, but the result (while falling on a Tuesday)
turned out to be only a differnce of 56 days. The answer
needs to be 61 days or more (not less) but still fall on a
given day (in this case, a Saturday).
 
This will land on the first Saturday beyond the 61 days
subtracted from the date in C25:

=C25-61-WEEKDAY(C25-61)

HTH
Jason
Atlanta, GA
-----Original Message-----
Yes, it's me again but with a Slightly different scenario:

In cell C25 = 6/5/2004
Cell C26 = 6/5/2004 - 61 (days)

But, I want the day to only fall on a Saturday (or a Tuesday as the case may be).
I tried using one of the formulas generously suggested
Click to expand...
yesterday, but the result (while falling on a Tuesday)
turned out to be only a differnce of 56 days. The answer
needs to be 61 days or more (not less) but still fall on a
given day (in this case, a Saturday).
 
Back
Top