software

I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59, and
60-69

what would the formual look like just using years eg born between 1976 and
1967 etc...

Thank you
hopeless

=CHOOSE(INT(I4/10),quot;quot;,quot;20-29quot;,quot;30-39quot;,quot;40-49quot;,quot;50-59quot;,quot;60-69quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Suequot; gt; wrote in message
...
gt; I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59,
and
gt; 60-69
gt;
gt; what would the formual look like just using years eg born between 1976 and
gt; 1967 etc...
gt;
gt; Thank you
gt; hopeless
Hi Bob,
It didn't seem to work.

my problem is this:

someone born in year quot;1972quot;, I need an if statement to calculate that this
would be someone between quot;30-39quot;

Unless I was suppose to substitute something the the formula that you gave
me. If so please talk me through it...I'm kinda new at these quot;if statementquot;.

Thank you
Sue

quot;Bob Phillipsquot; wrote:

gt; =CHOOSE(INT(I4/10),quot;quot;,quot;20-29quot;,quot;30-39quot;,quot;40-49quot;,quot;50-59quot;,quot;60-69quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Suequot; gt; wrote in message
gt; ...
gt; gt; I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59,
gt; and
gt; gt; 60-69
gt; gt;
gt; gt; what would the formual look like just using years eg born between 1976 and
gt; gt; 1967 etc...
gt; gt;
gt; gt; Thank you
gt; gt; hopeless
gt;
gt;
gt;

You haven't explained what the data you have in your sheet is - is it a
birthdate (e.g., an Excel date serial number), a numeric year (e.g., an
integer like 1972), or a text value, like quot;1972quot;.If it's a birthdate:

A1: lt;birthdategt;
B1: =CHOOSE(DATEDIF(A1,TODAY(),quot;yquot;)/10 1, quot;0-9quot;, quot;10-19quot;, quot;20-29quot;,
quot;30-39quot;, quot;40-49quot;, quot;50-59quot;, quot;60-69quot;)If it's a numeric year:

B1: =CHOOSE((YEAR(TODAY())-A1)/10 1, quot;0-9quot;, quot;10-19quot;, quot;20-29quot;,
quot;30-39quot;, quot;40-49quot;, quot;50-59quot;, quot;60-69quot;)In article gt;,
Sue gt; wrote:

gt; Hi Bob,
gt; It didn't seem to work.
gt;
gt; my problem is this:
gt;
gt; someone born in year quot;1972quot;, I need an if statement to calculate that this
gt; would be someone between quot;30-39quot;
gt;
gt; Unless I was suppose to substitute something the the formula that you gave
gt; me. If so please talk me through it...I'm kinda new at these quot;if statementquot;.

Thank you sorry if I wasn't clear the first time.

I am using the numeric year.

What does quot;totdayquot; refer to?
I'm guessing quot;Yearquot; means 2006 (if I am trying to calculate as of this year)

Thank you again
Susan

quot;JE McGimpseyquot; wrote:

gt; You haven't explained what the data you have in your sheet is - is it a
gt; birthdate (e.g., an Excel date serial number), a numeric year (e.g., an
gt; integer like 1972), or a text value, like quot;1972quot;.
gt;
gt;
gt; If it's a birthdate:
gt;
gt; A1: lt;birthdategt;
gt; B1: =CHOOSE(DATEDIF(A1,TODAY(),quot;yquot;)/10 1, quot;0-9quot;, quot;10-19quot;, quot;20-29quot;,
gt; quot;30-39quot;, quot;40-49quot;, quot;50-59quot;, quot;60-69quot;)
gt;
gt;
gt; If it's a numeric year:
gt;
gt; B1: =CHOOSE((YEAR(TODAY())-A1)/10 1, quot;0-9quot;, quot;10-19quot;, quot;20-29quot;,
gt; quot;30-39quot;, quot;40-49quot;, quot;50-59quot;, quot;60-69quot;)
gt;
gt;
gt; In article gt;,
gt; Sue gt; wrote:
gt;
gt; gt; Hi Bob,
gt; gt; It didn't seem to work.
gt; gt;
gt; gt; my problem is this:
gt; gt;
gt; gt; someone born in year quot;1972quot;, I need an if statement to calculate that this
gt; gt; would be someone between quot;30-39quot;
gt; gt;
gt; gt; Unless I was suppose to substitute something the the formula that you gave
gt; gt; me. If so please talk me through it...I'm kinda new at these quot;if statementquot;.
gt;

TODAY() (not totday). From XL Help (quot;TODAYquot;):

gt; TODAY
gt; Returns the serial number of the current date.

For YEAR(), from XL Help (quot;YEARquot;):

gt; YEAR
gt; Returns the year corresponding to a date. The year is returned as an
gt; integer in the range 1900-9999.In article gt;,
Sue gt; wrote:

gt; What does quot;totdayquot; refer to?
gt; I'm guessing quot;Yearquot; means 2006 (if I am trying to calculate as of this year)