Microsoft Office Tutorials and References
In Depth Information
Figure 12-15: Using the VDB function to calculate accumulated depreciation.
The formula computes the depreciation taken on the asset from the date it was purchased until the date it was
sold. The DATEDIF function is used to determine how many years the asset has been in service.