View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
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