This is my first post and I am a fairly new excel user. I am working on a spread sheet with a column (F) titled days pending where I have the formula =today()-E3 where column E is titled date received. I would like to make a third column (column H) that buckets the days pending into 4 categories of days old pending which are 1-10, 11-30, 31-60 and 61-120. So i need a formula that says if the number in a cell from column E is 1,2,3,4,5,6,7,8,9,10 the column H equals (1-10) .
Bookmarks