Why not add this to your existing formula which is adding an extra day to
the first day of next month as followis:-
=IF(WEEKDAY(A1,2)5,0,-1)
It will give a -1 if first day of next month is a weekend and your result
should be correct.

"Mark" wrote in 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.