Hi!

For total workdays in a given month with the first day of
the month entered into A1:

A1 = 3/1/2005


=NETWORKDAYS(A1,EOMONTH(A1,0))

To determine if a given date is a weekday or weekend with
Monday thru Friday being the traditional "weekdays" and
Monday being the FIRST day of the week:

=WEEKDAY(A1,2)<6

Will return a TRUE or FALSE. If you want some other
designation just put that into an IF function:

=IF(WEEKDAY(A1,2)<6,"Weekday","Weekend")

Biff

-----Original Message-----
Simply put, I need a function that will indicate if a
given date is a workday
or a weekend. I could also use a function that would
given me the
networkdays in a given month, without having to specify a
start and end date.
If you have any ideas, please let me know. What follows
is a detailed
explanation of what I am trying to do which may or may
not be helpful.
Thanks in advance!




I am working on a sheet that requires an IsWorkday
function. Essentially, I
have a function that counts the number of days in a given
month which uses
the NetWorkDays function.

This function was created so that a user can specify a
start date, and the
sheet will fill out the number of days within each month
from that date.

To do this, I have the first date in the NetWorkDays
function as the first
day of a given month. The second date is the first day
of the following
month.

The problem is that the function, as it currently stands,
is often off by 1
day because it is counting the first day of the following
month. I can't
simply make the second day of the NetWorkDays function
the last day of the
month, because I don't know if the month will have 28,
30, or 31 days.

Essentially, I need the IsWorkday function so that I can
put a constraint on
my existing function.
.