Why not use the EOMONTH() function to determine the last day of the month

Alternatively, use Date(year, month+1,1)-1 to determine the first day of
the next month and then subtract a day to let Excel calculate the last day of
the target month



"Mark" wrote:

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.