Depreciation is a method of allocating costs over the useful economic life of an asset (e.g. a building, a car, a computer). This function returns the depreciation of an asset for a specified period using what is known as the fixed-declining balance method (explained below).

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DCOUNTA function.

Today we look at the DCOUNT function. This function counts the cells that contain numbers [not text which looks like numbers] in a field (that’s jargon for a column!) of records in a list or table that match one or more conditions you specify.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DBCS function.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DB function.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DAYS360 function.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DAYS function.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DAY function.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DAVERAGE function.

This function converts a date that is stored as text to a serial number that Excel recognises as a date..