View Single Post
  #19  
Old November 5th, 2009, 12:33 AM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default How do I create formula to calc difference in dates?

You could just add one more to the result:

=a1-a2+1



Kenneth Green wrote:

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


--

Dave Peterson