Microsoft Office Tutorials and References
In Depth Information
DDE and External Functions
Returns the hour as a serial number integer between 0 and 23.
HOUR
Returns the serial number that corresponds to the minute.
MINUTE
Returns the corresponding serial number of the month between
1 and 12.
MONTH
Returns the number of working days between two dates.
Excludes weekends and specified holidays.
NETWORKDAYS
Returns the current date and time in the form of a serial number.
There are no arguments for this function. This function updates the
date and time each time the worksheet it appears on re-calculates.
NOW
Returns the corresponding serial number of seconds as an integer
between 0 and 59.
SECOND
Returns the corresponding serial number of time as a fraction or
decimal between 0 and 0.99999999.
TIME
Returns the serial number represented by text as time.
TIMEVALUE
Returns the current date as a serial number. There are no
arguments for this function. This function updates the date each time
the worksheet it appears on re-calculates.
TODAY
Returns the corresponding day of the week as a serial number.
WEEKDAY
Returns the corresponding year as a serial number in the form of
an integer.
YEAR
Returns the calculated fraction of the year represented by whole
numbers between two dates.
YEARFRAC
DDE and External Functions
For information on the following DDE and External functions, see Chapter 2, “Managing
Your Business with Functions.”
Calls up the procedure in a dynamic link librar y or code resource.
Syntax 1 is used in conjunction with the REGISTER function,
Syntax 2 uses the CALL function by itself.
CALL
Supplies the registered ID of the dynamic link librar y or code
resource.
REGISTER.ID
Runs a quer y from a worksheet and connects an external data
source.
SQL.REQUEST
Engineering Functions
BESSELI
Returns the Bessel function in modified form for imaginar y
arguments.
Search JabSto ::




Custom Search