# Workbook Functions D-H

DATE(year, month, day)

Serial number of the supplied date, where year is a number up to 9999 and month between 1 and 12.

DATEVALUE(text)

Serial number of a date supplied in text format (e.g. "3/6/1994") up to the year 9999.

DAY(serial number)

Day of the month that corresponds to the date represented by the given argument, be it a serial number (e.g. 34399) or a text (e.g. "21-06-1994").

DAY360(start_date, end_date, [method])

Number of days between two dates based on a 360 day year (twelve 30 day months). If method = true then the European system is used. If method = false or omitted then the US system is used.

DB(cost, salvage, life, period [, months])

Real depreciation of an asset for a specific period using the fixed-declining balance method. Cost is the initial cost of the asset, salvage is the salvage value of the asset and life is the number of periods in its useful life. Months is the number of months in the first year of the item's life (default is 12). The time units for life and period must match.

DDB(cost, salvage, life, period [,factor])

Depreciation of an asset for a specific period of time using the double-declining balance method or a declining balance factor supplied. Factor is the rate at which the balance declines (default value is 2). All entries must be >0.

DOLLAR(number [,precision])

Returns the number as text, using currency format. The number of decimal places to the right of the decimal point is indicated by precision.

ERROR.TYPE(reference)

Number corresponding to an error occurring in the specified reference cell.

EVEN(number)

Rounds the specified number up to the nearest even integer.

EXACT(expresion1, expression2)

True if the two text expressions are identical (case-sensitive); False if not.

EXP(Any number)

e (e=2.71828183) raised to the specified power.

FACT(Non-negative integer)

Factorial of a specified number.

FALSE( )

Logical value False.

FIND(search text, text [,start position])

Searches for the specified search text within another text and returns the character position at which the search string first occurs. Start position in text where the search begins (default is 1).

FIXED(Any number [, precision][,no commas])

Rounds the number to the supplied precision. No commas determines if thousands separators (commas) are used in the result.

FLOOR(Any number, significance)

Rounds a number down to the nearest multiple of a specified significance.

FV(interest, number of payments per annuity, payment [,present value of annuity] [,type])

Future value of an annuity based on regular payments and a fixed interest rate. Type indicates when the payments are due: 0 for the end of period, 1 for the beginning of the period.

HLOOKUP(search item, search range, row index)

Searches the top row of the specified search range for the search item and returns the contents of the cell in the same column as the search item and row given by row index. Contents in first row must be in ascending order (e.g. -1,0,1,...A,...Z,FALSE,TRUE).