If you want to get difference in days

来源: 2007-12-09 08:22:03 [博客] [旧帖] [给我悄悄话] 本文已被阅读:

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