Excel/Open Office date difference

You can get date difference between 2 dates on spreadsheet column by using below formula

=A1-B1

Screenshot