How to subtract weekend days?

[GJones]

Hi simsjr;

Pasted below is the VBA help for the WeekDay method. As
long as your worksheet has the dates for each day you
should be able to use the method to add up the weekdays
instead of minusing the weekend days out.


WeekdayName Function


Description

Returns a string indicating the specified day of the week.

Syntax

WeekdayName(weekday, abbreviate, firstdayofweek)

The WeekdayName function syntax has these parts:

Part Description
weekday Required. The numeric designation for the day of
the week. Numeric value of each day depends on setting of
the firstdayofweek setting.
abbreviate Optional. Boolean value that indicates if the
weekday name is to be abbreviated. If omitted, the default
is False, which means that the weekday name is not
abbreviated.
firstdayofweek Optional. Numeric value indicating the
first day of the week. See Settings section for values.



Settings

The firstdayofweek argument can have the following values:

Constant Value Description
vbUseSystem 0 Use National Language Support (NLS) API
setting.
vbSunday 1 Sunday (default)
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday



Thanks,

Greg