Hi guys.

I have a spreadsheet which details a list of fixed assets that mature over a
period of time. Now i need to know which items fall into which categories
without having to work it out manually!
An example of my spreadsheet is:

Item Acquisition Fully Dep'n Cost Current Depn WDA
x 01/05/06 30/04/11 300 250
50

I have the current date in cell J1 and the depreciation is calculated from
this, now imagine the list being very long full of different items fully
depreciating at different times.

I need to put the current WDA figure of each item into one of the following
groups dependant on when that item is fully depreciated:

0-3Months
3-6Months
6-12Months
1-5years
Over 5years

Please help! Thanks.
Tom.