Pete thank you for your patience you must think I a nurd. but i'm trying. I
did what you suggested and i even played around with the formulas. I don't
know if this makes a difference but the user can put in any dates up to three
years.when i inserted your formulas the last date went to 12/31/what ever
year. if the user puts in 1/2/05 to 1/1/08 the last year should go tfrom
1/1/05 to 1/2/05 instead it goes to 12/31/05.

lues"904allen" wrote:

Dates Range need Help
Example
[A1 has date 3/1/08] [B1 has date 3/1/05} date between A1 and B1 will never
be more than 3 years. How do I get Excel list
A2=1/1/08 B2=3/1/08 or A2=3/1/08 B2=1/1/08
A3=12/31/07 B2=1/1/07 or A3=1/1/07 B3=12`/31/07
A4=12/31/06 B4=1/1/06 or A4=1/1/06 B3=12/31/06
A5=3/1/05 B5=12/31/05 or A5=1/1/05 B5=3/1/05
As stated the dates in A1 to B2 will never be more then 3 years but can be
any date between 3 years. As you can see I have to have excel list each year
by date