I need to group the dates as follows...
Number < week old
Number >1 week but < 1 month old
Number >1 month but < 3 months old
Number >3 months but < 6 months old
Number > 6 months
=IF(AR6<7,"< 1 Week",IF(AR6<30,">1 week & < 1 month old",IF(AR6<31,">1 Month & < 3month old",IF(AR6<90,"> 3month old & < 6 Months",IF(AR6<182,"> 3month old & > 6 Months)))))))
Not working ?
Number < week old
Number >1 week but < 1 month old
Number >1 month but < 3 months old
Number >3 months but < 6 months old
Number > 6 months
=IF(AR6<7,"< 1 Week",IF(AR6<30,">1 week & < 1 month old",IF(AR6<31,">1 Month & < 3month old",IF(AR6<90,"> 3month old & < 6 Months",IF(AR6<182,"> 3month old & > 6 Months)))))))
Not working ?