Age Category Formula for Excel

'You will need to change the cell reference From I2 to the cell which contains Age.

'Ageing Formula

=IF(I2>180,"Over 180 Days",IF(I2>120,"121 - 180 Days",IF(I2>90,"91 - 120 Days",IF(I2>60,"61 - 90 Days",IF(I2>30,"31 - 60 Days",IF(I2>15,"16 - 30 Days",IF(I2>10,"11 - 15 Days",IF(I2>5,"6 - 10 Days","Under 5 Days"))))))))