Nested (?) if statement

  • Thread starter Thread starter Marcy
  • Start date Start date
M

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.
 
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.
 
Marcy said:
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?
Click to expand...

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)
 
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!
 
Back
Top