Subsequent Saturday

M

Marcy

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.
 
G

Gaurab Hazarika

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).
 
J

Jason Morin

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subsequent Saturday 5
Search closest day in the past from today 2
Show dates based on criteria 3
Week ending Thursday formula 4
Date calculation 3
Difference - except for Saturdays and Sundays 10
Generate Payment Due Date to exclude Weekends and Public Holiday 4
ship on Tuesday 6

Top