counting days

[Guest]

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

 

[Nick Hodge]

Belvy

Try

=B6-B5

and then format the result as general (Format>Cells>Number>General)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[David Biddulph]

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