Apple numbers User Manual
226
Chapter 12
Dictionary of Functions
DAY
The DAY function extracts the day number from a date.
DAY(date-time)
 date-time: Any valid Numbers date.
DB
The DB function calculates the depreciation of an asset for a specified period using the
fixed-declining balance method.
fixed-declining balance method.
DB(cost, salvage, life, period, [first-year-months])
 cost: The initial cost of the asset.
 salvage: The salvage value of the asset.
 life: The number of periods over which the asset is depreciating.
 period: The period for which you want to calculate the depreciation.
 first-year-months: Optional; the number of months in the first year. If omitted, 12 is
 salvage: The salvage value of the asset.
 life: The number of periods over which the asset is depreciating.
 period: The period for which you want to calculate the depreciation.
 first-year-months: Optional; the number of months in the first year. If omitted, 12 is
assumed.
Examples
DAY("4/6/88 11:59:22 AM") returns 6.
Examples
If A2:E2 contain 1000, 100, 4,1,12:
DB(A2, B2, C2, D2, E2) returns $438.
DB(A2, B2, C2, 2, E2) returns $246.16.
DB(A2, B2, C2, 3, E2) returns $138.34.
DB(A2, B2, C2, 4, E2) returns $77.75.
DB(A2, B2, C2, D2, 9) returns $328.50.
DB(A2, B2, C2, D2, 6) returns $219.
DB(A2, B2, C2, D2, 3) returns $109.50.