Calculate days between dates

S

sunita_shaw

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 !!!!
 
S

SteveG

In C1,

=B1-A1+1

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

HTH,

Steve
 
S

sunita_shaw

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...
 
S

SteveG

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
 
Top