creating a series within a formula

hello,
i tried searching but was unable to find a solution. sorry if this is a repost.

issue 1
i'm trying to create values (text and numbers) for a column where the bulk of the information is concatenated. the dilemma lies in trying to have the last 3 characters as dynamic numbers that increase down this column. following is what i have, but i don't know what to replace "001" with:

=CONCATENATE(E2, F2, G2, H2, "001")

for example, following would be results that i would need:

AOI050101001
AOI050101002
AOI050101003
AOI050101004
...


issue 2
i have a column containing numerical values (01 - 11), and another column with dates formatted as MMDDRR (ie: 012805). what i would like to do is have the date column calculate itself based on the numerical value.

thus, if the numerical value is 01, then the date is 012805
...02 then 012905
...03 then 013005

any suggestions are certainly appreciated. thanks for looking and let me know if further details are needed!

hi Duane,
first off, thx for taking the time to help. i tried your suggestions and came across a couple snags:

Originally Posted by duane

for the first question, one approach is to use the row() function if you want to copy the formula down a column

=CONCATENATE(E2, F2, G2, H2, "00", row())

will result in 001 on row 1, 002 on row 2, etc.

for more than 10 rows add this

=CONCATENATE(E2, F2, G2, H2, "0", if(row()<10,"0",""),row())

your suggestion works, but i wasn't clear on what i needed to output. my column H2 contains values ranging from 00 to 11. is there any way to have the row #'s repeat for each different value of H2? in other words:

AOI050101002
AOI050101003
AOI050101004
...

AOI050104002
AOI050104003
AOI050104004

Originally Posted by duane

for question two try this

=DATEVALUE("01/27/05")+a1

if a1 is where your "numerical value" is

this one didn't work b/c the returned value is a serial number. is there any way to keep the output as a date without any separators?

thanks again for at least getting me started in the right direction!