View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel Formula to calulate number of days passed from date to date

Just subtract them and format the cell as General.

=b2-a2

(or if you want to include one of the end dates)

=b2-a2+1
(or +2 for both days???)

K. Mack wrote:

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.


--

Dave Peterson