Hello,
Every week I have a set of open tickets with various dates. I need to break these Dates down to certain ranges.
Current Date Aged Date Range Value to assign
10/20/2013 10/18/13 < = 3 days A1
10/20/2013 10/7/13 > 3 days & < 2 weeks A2
10/20/2013 9/23/13 2 weeks - 4 weeks A3
10/20/2013 9/22/13 > 4weeks A4
I need in cell H:2 a value returned of with A1 thru A4 based on the results of the information in Columns A:D.
So basically it shoudl have in column H a bunch that fall in the reange of 3 day or less with "A1" then the dates that fall in the range of greater then 3 days but less then 2 weeks a value of "A2", etc. I hope i made this clear enuf to understand.
OK..I dont see where i can add an attachement
Bookmarks