Calculate days between dates

Theres a problem I came across:
I would like to add the days between two cells

e.g:
A B
03/12/2006 03/20/2006

I want the total number of days that I took to complete my task i.e 9days
How do I get this 9days..what is the formula....

Someone Plzz help !!!!

In C1,

=B1-A1+1

Format the cell of your result as General or Number to 0 decimal places.

HTH,

Steve

One way:

=B1-A1+1

Format as General or Number.

In article <sunita_shaw.24b4v7_1141748276.0263@excelforum-nospam.com>,
sunita_shaw <sunita_shaw.24b4v7_1141748276.0263@excelforum-nospam.com>
wrote:

> Theres a problem I came across:
> I would like to add the days between two cells
>
> e.g:
> A B
> 03/12/2006 03/20/2006
>
> I want the total number of days that I took to complete my task i.e
> 9days
> How do I get this 9days..what is the formula....
>
> Someone Plzz help !!!!

Hi! Steve , I tried but my dates get formated into plain numbers and when I try doing it some other sheet too I get the difference in the form of dates...

Sunita,

Keep the cells where your dates are formatted as dates. Only change the format of the cell that you input the formula into to a number to return only a number.

Steve