View Single Post
  #18  
Old November 5th, 2009, 12:11 AM posted to microsoft.public.excel.misc
Peo Sjoblom[_3_]
external usenet poster
 
Posts: 137
Default How do I create formula to calc difference in dates?

To me it is only 6 days, how do you get 7?

--


Regards,


Peo Sjoblom


"Kenneth Green" Kenneth wrote in message
...
Hi Biff

If I wanted to use a formual to count days including the start date and
end
dates what would i use?

e.g days between january 1, 2009 - january 7, 2009 is seven days, but
using
the formulas it gives a result of 6 instead of seven

Thanks
Ken