Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
DATEVALUE(date_text) [Category: Date & Time]
Returns the serial number of the date represented by date_text. Use
DATEVALUE to convert a date represented by text to a serial number. Guru
Tip: Use DATEVALUE to correct a spreadsheet where all of the dates have
been entered as text. If you don’t format the cell that contains DATEVALUE, you
will see the serial number used to represent the date. In the image below, you
can format column B as a date to display the results as a date. On a Windows
PC, 40363 is the serial number for July 4, 2010. Note that DATEVALUE works
with some surprising abbreviations such as 4-Jul-2010, but then fails with
others such as Jul-4-2010. The result of DATEVALUE will change based on
the Regional and Language option of your computer. In many countries, the
DATEVALUE("07/04/2010") will return April 7, 2010.
DAVERAGE(database,fi eld,criteria) [Category: Database]
Averages the values in a column in a list or database that match conditions that
you specify. Guru Tip: See DSUM.
DAY(serial_number) [Category: Date & Time]
Returns the day of a date, represented by a serial number. The day is given as
an integer ranging from 1 to 31.
DAYS360(start_date,end_date,method) [Category: Date & Time]
Returns the number of days between two dates based on a 360-day year
(twelve 30-day months), which is used in some accounting calculations. Use
this function to help compute payments if your accounting system is based on
twelve 30-day months.
DB(cost,salvage,life,period,month) [Category: Financial]
Returns the depreciation of an asset for a specifi ed period using the fi xed-
declining balance method. Guru Tip: VDB seems to run circles around this
function.
DCOUNT(database,fi eld,criteria) [Category: Database]
Counts the cells that contain numbers in a column in a list or database that
match conditions that you specify. Guru Tip: See DSUM.
DCOUNTA(database,fi eld,criteria) [Category: Database]
Counts all of the nonblank cells in a column in a list or database that match
conditions that you specify. Guru Tip: See DSUM.
DDB(cost,salvage,life,period,factor) [Category: Financial]
Returns the depreciation of an asset for a specifi ed period using the double-
declining balance method or some other method you specify. Guru Tip: VDB
seems to run circles around this function.
 
Search JabSto ::




Custom Search