Excel using DATEDIF Function HELP!!!

[andej1026]

I am running into problems when using the DATEDIF function when calculating the difference in days with two dates. It is fine when the start date is less than or equal to the end date but where the problem is when the end date is earlier than the start date. I get an error (#NUM!) in all boxes where this happens. I would like for it to dislpay a negative number. My example is:

Due Date Receipt date
12/1/09 12/5/09 5 days

10/5/09 10/4/09 #NUM! I would like for it to display (-1)

Any help would be greatly appreciated.

[Domski]

Just use a formula like =B2-A2

Dom