Pedro's PhD
Board Regular
- Joined
- Jun 3, 2011
- Messages
- 63
Have a little problem to solve here….
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
I have the age of a person when they join a society (C3), and the age when they leave the society (D3). I then have age categories 25-34, 35-44, 45-54. I need a formula to return the number of years they were in each category in cell F3, G3, H3 respectively.
<o
> </o
>
Example: A person joins at the age of 32 and leaves at the age of 46. They are in the first category 25-34 for 3 years (so F3 to read 3), in category 35-44 for 10 years (so G3 to read 10), and in category 45-54 for 2 years (so H3 to read 2).
<o
> </o
>
Is this possible?
<o
> </o
>
Thanks in advance,
<o
> </o
>
Pedro
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




I have the age of a person when they join a society (C3), and the age when they leave the society (D3). I then have age categories 25-34, 35-44, 45-54. I need a formula to return the number of years they were in each category in cell F3, G3, H3 respectively.
<o


Example: A person joins at the age of 32 and leaves at the age of 46. They are in the first category 25-34 for 3 years (so F3 to read 3), in category 35-44 for 10 years (so G3 to read 10), and in category 45-54 for 2 years (so H3 to read 2).
<o


Is this possible?
<o


Thanks in advance,
<o


Pedro