Excel experts around? Need assistance with a function

[imported_Rampage]

I'm working on a project and have two fields of data such as below:

A B
11-Apr-05 8-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 15-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 19-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 15-Apr-05
11-Apr-05 26-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 13-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 22-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 15-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 15-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 17-Apr-05
11-Apr-05 20-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 22-Apr-05
11-Apr-05 22-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 21-Apr-05
11-Apr-05 14-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 9-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 12-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 8-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 9-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 11-Apr-05
11-Apr-05 9-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 13-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 20-Apr-05
11-Apr-05 28-Apr-05
11-Apr-05 10-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 9-Apr-05
11-Apr-05 15-Apr-05
11-Apr-05 16-Apr-05
11-Apr-05 9-Apr-05
11-Apr-05 18-Apr-05
11-Apr-05 7-Apr-05
11-Apr-05 7-Apr-05


What function would I use to compare the two columns. And if they differ, count the difference only if its over 1?

Thanks in advance.. the Excel helpfile isnt incredibly useful and I havent used Excel forever

 

[xtknight]

Disregard my last idiotic post. Uhh...not sure. :Q

 

[Thyme]

You can use the "if" function on the outside and on the inside you should be able to use days360

 

[wkinney]

Put this in C1 in your excel sheet:
=IF(A1=B1,"",IF(DATEDIF(A1,B1,"D")>1,DATEDIF(A1,B1,"D"),""))

then highlight the rest, C2:C<whatever>, paste

this will print nothing if they are the same or <= 1 day diff,
the amount of days if > 1 day diff

 

[imported_Rampage]

Thanks for the responses!!!

I figured out my own way of doing it, i'll explain soon I have to go grab something to eat.. (i'm going to try the suggestions tomorrow though)

i work for john deere and just could not figure that out today.

btw, WKinney: my last name is Kinney too! hehe