C
cjwenngatz
I have a list of assets in column A.
Column B contains a historical date (Jan, 2008)
Column C contains current months date (Nov, 2009).
Column D shows the period difference (B-C) = 21
Now here comes the fun part, I need to know what the NBV of the asset
is using 20% declining balance). This formula will be copied to
multiple assets, so it needs to be dynamic.
I've tried everything I can think of :S
Thanks!
Column B contains a historical date (Jan, 2008)
Column C contains current months date (Nov, 2009).
Column D shows the period difference (B-C) = 21
Now here comes the fun part, I need to know what the NBV of the asset
is using 20% declining balance). This formula will be copied to
multiple assets, so it needs to be dynamic.
I've tried everything I can think of :S
Thanks!