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