I am having difficulty creating a dynamic depreciation schedule that incorporates assets with different start dates and useful lives. My main blocker is creating formulas in cells 26-28 that start the depreciation schedules only when there is spending and end at the end of the useful lives. For example, how can I ensure that an asset with a 12 month useful life that's purchased in July 2023 finishes depreciating in 12 months. Right now, I am struggling with stopping the depreciation at the end of the of useful life. Please see the attached. Thank you in advance.
Bookmarks