View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default count days from a one date to another date

No, John. The OP asked for "the number of days from A1 to B1", so your
answer of -262 was correct.
--
David Biddulph

"John" wrote in message
...
Correction on formula
=A1-B1
Sorry for my blindness.
John
"John" wrote in message
...
HI
Try this: =B1-A1
You must format the cell as "General"
HTH
john
"confused!!" wrote in message
...
If in cell A1 i have a date 09/17/09 and date 10/30/08 in B1 i need to
count
the number of days from A1 to B1

Please provide formula for doing so.