Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
WEEKNUM(serial_num,return_type) [Category: Date & Time]*
Returns a number that indicates where the week falls numerically within a
WEIBULL(x,alpha,beta,cumulative) [Category: Statistical]]
Returns the Weibull distribution. Use this distribution in reliability analysis, such
as calculating a device’s mean time to failure.
WORKDAY(start_date,days,holidays) [Category: Date & Time]*
Returns a number that represents a date that is the indicated number of working
days before or after a date (the starting date). Working days exclude weekends
and any dates identiﬁ ed as holidays. Use WORKDAY to exclude weekends or
holidays when you calculate invoice due dates, expected delivery times, or the
number of days of work performed. To view the number as a date, click Cells on
the Format menu, click Date in the Category box, and then click a date format in
the Type box. Guru Tip: Say that you hire an employee and need to know when
a 60-workday probation period is over. Just as in the NETWORKDAYS example,
you can specify a range of holidays as the third argument in the function. This
function assumes that your workweek is the ﬁ ve days from Monday through
Friday. If you work any other work week, see page 4.
XIRR(values,dates,guess) [Category: Financial]*
Returns the internal rate of return for a schedule of cash ﬂ ows that is not
necessarily periodic. To calculate the internal rate of return for a series of periodic
cash ﬂ ows, use the IRR function.
XNPV(rate,values,dates) [Category: Financial]*
Returns the net present value for a schedule of cash ﬂ ows that is not necessarily
periodic. To calculate the net present value for a series of cash ﬂ ows that is
periodic, use the NPV function.
YEAR(serial_number) [Category: Date & Time]
Returns the year corresponding to a date. The year is returned as an integer in
the range 1900-9999. Guru Tip: Use YEAR, MONTH, DAY, HOUR, MINUTE, and
SECOND to break a date and time into component parts. Join the component
parts back into a date using DATE or TIME.