ship on Tuesday

[Marcy]

Harlan Grove was kind enough to solve one mystery for me a few days ago by suggesting the formula =MIN(C24,C25-49) to get the earlier date between two options.

I was wondering if this formula (or another, perhaps?) can give me the date but that the date would only fall on a Tuesday

For example, if the ship to customer date is 6/25/04 (cell C25) and the x-factory date is 4/12/04 (C24), for cell C26, I would use the above formula, but is it possible for the result to fall on a Tuesday? If so, how can I re-write this

Hope everyone had a great holiday and that you're not too full to concentrate today!

 

[Paul]

Harlan Grove was kind enough to solve one mystery for me a few days ago by

suggesting the formula =MIN(C24,C25-49) to get the earlier date between two
options.

I was wondering if this formula (or another, perhaps?) can give me the

date but that the date would only fall on a Tuesday.

For example, if the ship to customer date is 6/25/04 (cell C25) and the

x-factory date is 4/12/04 (C24), for cell C26, I would use the above
formula, but is it possible for the result to fall on a Tuesday? If so, how
can I re-write this?

Hope everyone had a great holiday and that you're not too full to

concentrate today!

How about this:
=MIN(C24,C25-49)-WEEKDAY(MIN(C24,C25-49)-1,3)

 

[Marcy]

Thank you so much! This worked perfectly
One quick question...does the 3 indicate Tuesday so that if I wanted to change the argument to Saturday for example, I could substitute 7

 

[Peo Sjoblom]

The last minus part decides that, for Saturday change to -5

--

Regards,

Peo Sjoblom

Thank you so much! This worked perfectly!
One quick question...does the 3 indicate Tuesday so that if I wanted to

change the argument to Saturday for example, I could substitute 7?

 

[marcy]

Thanks, Peo. But, can you please tell me then, what does the 3 indicate at the end of the formula

----- Peo Sjoblom wrote: ----

The last minus part decides that, for Saturday change to -

--

Regards

Peo Sjoblo

Thank you so much! This worked perfectly
One quick question...does the 3 indicate Tuesday so that if I wanted t

change the argument to Saturday for example, I could substitute 7

 

[Peo Sjoblom]

How to index the weekdays, nothing or 1 numbers Sunday 1 - Saturday 7,
2 numbers Monday 1 - Sunday 7 and 3 numbers Monday 0 - Sunday 6

 

[marcy]

Thanks for explaining, Peo. Please enjoy your weekend. You have made mine much easier!!