Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date formula
In a formula relative to straight line depreciation, I have to cells I need
to fill in with formulas. The first cell requires the first year of the total useful life of the asset. The acquisition date is taken from a vlookup. The first cell would be a year's worth of depreciation less one month. The second cell requires the next full year's amount of depreciation. The project requires that when you click on a specific asset, the column lists all the years depreciation starting with the first year in the first cell of the column to the last year. I know this sounds confusing, but can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |