Excel 2010 Bible

Appendix A: Worksheet Function Reference

921

Function What It Does

MINUTE Converts a serial number to a minute.

MONTH Converts a serial number to a month.

NETWORKDAYS Returns the number of whole workdays between two dates.

NETWORKDAYS.INTL* Returns the number of whole workdays between two dates (international version).

NOW Returns the serial number of the current date and time.

SECOND Converts a serial number to a second.

TIME Returns the serial number of a particular time.

TIMEVALUE Converts a time in the form of text to a serial number.

TODAY Returns the serial number of today’s date.

WEEKDAY Converts a serial number to a day of the week.

WEEKNUM Returns the week number in the year.

WORKDAY Returns the serial number of the date before or after a specified number of work days.

WORKDAY.INTL* Returns the serial number of the date before or after a specified number of work days

(International version).

YEAR Converts a serial number to a year.

YEARFRAC Returns the year fraction representing the number of whole days between start_date and

end_date.

* Indicates a function introduced in Excel 2010.

TABLE A.5

Engineering Category Functions

Function What It Does

BESSELI Returns the modified Bessel function In(x).

BESSELJ Returns the Bessel function Jn(x).

BESSELK Returns the modified Bessel function Kn(x).

BESSELY Returns the Bessel function Yn(x).

BIN2DEC Converts a binary number to decimal.

BIN2HEX Converts a binary number to hexadecimal.

BIN2OCT Converts a binary number to octal.

COMPLEX Converts real and imaginary coefficients into a complex number.

CONVERT Converts a number from one measurement system to another.

continued

56_474877-bapp01.indd 92156_474877-bapp01.indd 921 3/29/10 11:49 PM3/29/10 11:49 PM