Create a formula with a date range

K

Kimber

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top