Formula using sumif depending on date in two cells

Hello,

I hope I can explain this well enough. I need a formula that checks for the oldest date in two different cells then calculates the sum.

So, this is what I want to put in cell E2

If date in A2 > date in C2 then B2 - D2 and If date in C2 > date in A2 then D2 - B2

Except I want it in a real formula

Thx
E.

Would this be a simple IF -THEN kind of problem? Like this:

Formula:

Please Login or Register  to view this content.

- Moo

Thanks, but it doesn't account for date in C2 being greater then the date in A2.

Yes, it does.. that is what the IF statement does - exactly.

=IF( LOGICAL CONDITION , DO 'THIS' IF TRUE , DO 'SOMETHING ELSE' IF FALSE )

In every day terms my formula says:

IF A2 is greater than C2, THEN subtract D2 from B2, OTHERWISE (if A2 is NOT greater than C2) subtract B2 from D2.

The only problem you would run into would be if A2 = C2.

- Moo

Thanks Moo, it works, but I'm running into the problem of the A2 = C2. I need to look at this some more and get back to the forum.

Well, what would you like the result to be when A2 = C2? That is an easy fix for this formula. The way the formula is set up right now " =if(A2>C2,B2-D2,D2-B2) " the condition A2 = C2 will return FALSE since A2 is NOT greater than C2, thus it will do the second result (D2-B2).

When they are equal, do you want it to return an error, or a different value or formula? Let me know.

- Moo

Formula:

Please Login or Register  to view this content.