Difference in dates in Excel 2007
I guess I misled all of you in B1 I have turns out to ne 25
Sept 2007.
My question is this : What do I haveto do to get the answer 2
Thanks
"pcor" wrote:
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
|