View Single Post
  #8   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 Dave
(or +2 for both days???)


No, just 1 to add.
05 Jan 07 - 01 Jan 07 = 4

Actual days 01,02,03,04,05 = 5
--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
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