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

所有跟帖： 

• 到底是导师啊，原来偶的format不对。今天又学一招 ：） -依然悠悠- ♀ (0 bytes) () 12/09/2007 postreply 08:25:19

• 到底是教授啊！ 条理忒清楚:) -老妈也恋网- ♀ (0 bytes) () 12/09/2007 postreply 08:28:47

• 同志们，说俺是叫兽，那是抬举。。。勿信。 -笨企鹅- ♀ (0 bytes) () 12/09/2007 postreply 08:42:23

• 嗯，原来就差这了，当不上教授俺绝对不窝囊 -lanchan- ♀ (0 bytes) () 12/09/2007 postreply 08:53:25