=B6-B5.
Format as Number or General, not as date.
--
David Biddulph

"belvy123" wrote in message
...
Hi all

I have a sheet where I want to be able to count the days that a part on my
press has been in service
I have 2 cells that I will input the dates into
they are B5 and B6

B% is the cell that has the date that the part was last changed on
and B6 is the date it is currently being chnaged out on.
I need a formula that will count the actual days that the part had been in
service between the 2 change outs

Thanks for the help
--
crunchnin numbers