Formulas and Functions

MONTHNAME
The MONTHNAME function returns the name of the month from a number. Month 1 is
January.
MONTHNAME(month-num)
 month-num: The desired month. month-num is a number value and must be in the
range 1 to 12. If month-num has a decimal portion, it is ignored.
Examples
=MONTHNAME(9) returns September.
=MONTHNAME(6) returns June.
Related Topics
For related functions and additional information, see:
“DAYNAME” on page 48
“MONTH” on page 53
“WEEKDAY” on page 59
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
NETWORKDAYS
The NETWORKDAYS function returns the number of working days between two dates.
Working days exclude weekends and any other specied dates.
NETWORKDAYS(start-date, end-date, exclude-dates)
 start-date: The starting date. start-date is a date/time value.
 end-date: The ending date. end-date is a date/time value.
 exclude-dates: An optional collection of dates that should be excluded from the
count. exclude-dates is a collection containing date/time values.
Example
=NETWORKDAYS(”11/01/2009”, “11/30/2009”, {”11/11/2009”,”11/26/2009”}) returns 19d, the number of
working days in November 2009 excluding weekends and the two holidays specically excluded.
54 Chapter 3 Date and Time Functions