On Fri, 24 Aug 2007 20:08:01 -0700, Kimber
wrote:

i have a list of dates that i want to pull into one roll if
example: IF dates between 7-1-07 and 7/8/07 than choose 7/8/07

Is between inclusive?

What if date is not between the two dates?

In general:

=if(and(date=date1,date<=date2),date2,"date not between date1 and date2")


--ron