I don't know why you are having problems. Perhaps you can copy/paste
the actual formulae that you are using, particularly the ones in
column B, to see if there is any difference. You have included the $
symbols where they appear in my formulae?

Alternatively, send me an email to:

pashurst <at auditel.net

and I'll send you my working file back. If you like, you can attach
your own file.

Pete

On Mar 29, 8:31*pm, 904allen
wrote:
Pete, I did exactly what you suggested. the formulas worked if I put them in
ater I put in the dates except for the last date it still went to the end of
the year not the end of the date inserted. also if I put the forulas in first
it sets the in daye onthe cells at the end date in all cells. does it have
some thing to fo the progrem I'm using 2003 or do I need to set something
before running your formulas.



"904allen" wrote:
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- Hide quoted text -

- Show quoted text -