If you want to get difference in days
1)Set up the ColumnA and the ColumnB in Date format mm/dd/yyyy
2)Set up the ColumnC in Number format with zero decimal places.
3)Highlight the ColumnC, and type following formular:
=B1-A1
then, hit the Enter key. You will get an integer of days difference