Belvy
Try
=B6-B5
and then format the result as general (FormatCellsNumberGeneral)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"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