ship on Tuesday

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

Guest

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!
 
Marcy said:
Harlan Grove was kind enough to solve one mystery for me a few days ago by
Click to expand...
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
Click to expand...
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
Click to expand...
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
Click to expand...
concentrate today!

How about this:
=MIN(C24,C25-49)-WEEKDAY(MIN(C24,C25-49)-1,3)
 
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
 
The last minus part decides that, for Saturday change to -5

--

Regards,

Peo Sjoblom

Marcy said:
Thank you so much! This worked perfectly!
One quick question...does the 3 indicate Tuesday so that if I wanted to
Click to expand...
change the argument to Saturday for example, I could substitute 7?
 
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

Marcy said:
Thank you so much! This worked perfectly
One quick question...does the 3 indicate Tuesday so that if I wanted t
Click to expand...
change the argument to Saturday for example, I could substitute 7
 
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
 
Back
Top