MS Excel: Math formula about dates : Doubt

Question

Once cell has one date, another cell has another date..in the third cell i want to get this result: Difference of two dates if positiove number, or 0 if negative number.

Answer 1

Let us assume you have two dates in cells say A1, B1

First make sure that both columns A and B are in date format.

Now, in C1, write the formula "=IF(DAYS360(A1,B1) > 0, DAYS360(A1,B1), 0)"

This will return the difference in dates if B1 is latest date than A1.

i.e., B1 > A1.

If A1 > B1, it will return 0.