Thread: Difference in dates in Excel 2007
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
  
Posts: 148
Default Difference in dates in Excel 2007
Cell b1= 25 Sept 2007
Cell b2= 23 Sept 2007
Both cells are formatted as shown
With the following formula in B3 (B1-b2) I get answer of 3. I thought the
answer would be 2.
Can you tell me why oir how to fix it
Thanks

Reply With QuoteReply With Quote