Nested (?) if statement

[Marcy]

I am trying ot write a formula that will return a date
based on the following:

Cell C25 = 6/25/2004
Cell C24 = 4/7/2004
Cell C26 should return a date that is 6/25/2004 less 49
days if the date in C24 is less than the 49 days required.

Conversely, if the date in C25-C24 is GREATER than 49
days, I want the formula to return the date htat would
equal the 49 days from C25-49.

Can someone help me? You always do!!
Thanks to all in advance.

 

[Don Guillett]

Chip has a lot of good info on dates and times
http://www.cpearson.com/

 

[Marcy]

I did it MYSELF!! But, you guys still get all the credit
for teaching me so well ofr so long!

=IF(C25-C24<=49,C25-49,IF(C25-C24>49,C25-C24))

Isn't that right?

Thanks, excel compatriots.
Have a wonderful Thanksgiving.

 

[Harlan Grove]

I did it MYSELF!! But, you guys still get all the credit
for teaching me so well ofr so long!

=IF(C25-C24<=49,C25-49,IF(C25-C24>49,C25-C24))

Isn't that right?

If C24 and C25 are both *recent* dates, then they're both on the order of
37,000 when shown as integers. 49, on the other hand, is in the middle of
February 1900. C25-49 is 49 days before the date in C25, so still on the
order of 37,000, but C25-C24 would be on the order of 100.

If you want the *earlier* of C24 and C25-49, use

=MIN(C24,C25-49)

 

[Guest]

Is there anyway to make the resultant date ONLY be on a TUESDAY? That's when the ship sails so the information would be far more accurate that way

Is this possible

Thanks!