View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Excel Formula to calulate number of days passed from date to date

Hi

With start in A1 and end in B1
=B1-A1

Add +1 is if you want to include the whole of the first day and the
whole of the last day

--
Regards

Roger Govier


"K. Mack" wrote in message
...
Hi guys & gals,

I am working on a spreadsheet that has a column with a start date and
another column with an end date and the third column should total the
amount
of days between the two. I can't find a formula to do this. Any help
would
be greatly appreciated. I'm sure it's someting simple that I'm
missing but I
am almost ready to pull my hair out. Thanks.