counting days
 

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

counting days
 

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

counting days
 

=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