Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting days? | Excel Discussion (Misc queries) | |||
Counting days formula | Excel Discussion (Misc queries) | |||
Counting days | Excel Discussion (Misc queries) | |||
Counting days | Excel Worksheet Functions | |||
counting days | Excel Discussion (Misc queries) |