G Guest Aug 25, 2007 #1 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
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 Aug 25, 2007 #2 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
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
