David W 123
New Member
- Joined
- May 14, 2020
- Messages
- 9
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi everyone - I was hoping someone could please help me (this is my first time posting so fingers crossed!)
I have a list of assets (many thousand) with different purchase dates. I would like the cost to be depreciated over 12 months in line with the top table (% varies by month). I've manually completed asset number 1 as an example.
Is there a nice formula that could please help me do this analysis for several thousand assets?
Many thanks!
I have a list of assets (many thousand) with different purchase dates. I would like the cost to be depreciated over 12 months in line with the top table (% varies by month). I've manually completed asset number 1 as an example.
Is there a nice formula that could please help me do this analysis for several thousand assets?
Many thanks!