I have a spreadsheet that tracks placements of children. A child can move
into or out of a home on any given day. I would like to calculate on a
monthly basis how many days a child was in a particular home. Example. For
an October report: The child moved in on 10/3/05 and is still there. He
would have been there 28 days. I am very familiar with formulas but I am
unable to think of a way to capture this. Please help!

could it be as simple as
=today()-datemovedin
or do you need to search for the name with MATCH and then use INDEX to find
the date? If so, how about giving more info so we can help.

--
Don Guillett
SalesAid Software

" Pivot Table/Query" wrote
in message ...
I have a spreadsheet that tracks placements of children. A child can move
into or out of a home on any given day. I would like to calculate on a
monthly basis how many days a child was in a particular home. Example.
For
an October report: The child moved in on 10/3/05 and is still there. He
would have been there 28 days. I am very familiar with formulas but I am
unable to think of a way to capture this. Please help!

I already have a cell to calculate the total days of placement for open
placements. What I need specifically is to do a monthly report that would
show for each child the total number of days they were in any home. IE: if
John Taylor moved into the Smith Home on 9/3 and then moved on 9/27 into the
Gray Home, he would be listed 2 times, each with the total # of days in each
home. I need this to calculate payment for each home. Does that make sense?

"Don Guillett" wrote:

could it be as simple as
=today()-datemovedin
or do you need to search for the name with MATCH and then use INDEX to find
the date? If so, how about giving more info so we can help.

--
Don Guillett
SalesAid Software

" Pivot Table/Query" wrote
in message ...
I have a spreadsheet that tracks placements of children. A child can move
into or out of a home on any given day. I would like to calculate on a
monthly basis how many days a child was in a particular home. Example.
For
an October report: The child moved in on 10/3/05 and is still there. He
would have been there 28 days. I am very familiar with formulas but I am
unable to think of a way to capture this. Please help!