Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Data That Lies Between Two Dates
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Data from Date Range base on relative dates | Excel Worksheet Functions | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Finding the cell in which an object lies | Charts and Charting in Excel | |||
Adding Column of mixed data omitting the dates | Excel Discussion (Misc queries) | |||
Adding dates | Excel Worksheet Functions |