Subsequent Saturday

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

Guest

Yes, it's me again but with a NEW question (sort of!

If I have cell C25=6/5/200
and cell C26 should return C25-61(days) but only fall on a Saturday (subsequent), can you please tell me how I can write this?

I tried, really I did. I used
=C25-61+WEEKDAY(5,3) but the day comes out to a Thursday (4/8/2004)

Thanks, as always.
 
One way

=(C25-61)+7-MOD(WEEKDAY(C25-61),8)


--

Regards,

Peo Sjoblom


Marcy said:
Yes, it's me again but with a NEW question (sort of!)

If I have cell C25=6/5/2004
and cell C26 should return C25-61(days) but only fall on a Saturday
Click to expand...
(subsequent), can you please tell me how I can write this?
 
Marcy,

Same as last time

=C24-61+(7-WEEKDAY(C24-61,1))

And in case you then ask, what about Tuesday, then

=C24-61+CHOOSE(WEEKDAY(C24-61,1),2,1,0,6,5,4,3)

with the same sequence as before

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Marcy said:
Yes, it's me again but with a NEW question (sort of!)

If I have cell C25=6/5/2004
and cell C26 should return C25-61(days) but only fall on a Saturday
Click to expand...
(subsequent), can you please tell me how I can write this?
 
Yes, it's me again but with a NEW question (sort of!)

If I have cell C25=6/5/2004
and cell C26 should return C25-61(days) but only fall on a Saturday (subsequent), can you please tell me how I can write this?

I tried, really I did. I used:
=C25-61+WEEKDAY(5,3) but the day comes out to a Thursday (4/8/2004).

Thanks, as always..
Click to expand...

This formula will yield a result that is the next Saturday, unless the answer
falls on a Saturday, in which case it will be unchanged.

=$C$25-61+7-WEEKDAY($C$25-61)


--ron
 
Thank you to everyone but in each of the formulas offered, the result was 4/3/04 which results in 56 days. I need the result to be AT LEAST the 61 days AND fall on a Saturday.

Now what, coaches??
 
Sorry, everyone...I didn't mean to post this twice. Must have been a delay in appearing and I thought I needed to send again.

My apologies to the group.
 
Back
Top