M
mikebres
I'm trying to come up with a function that will give me the number of working
days between two dates. Unless I'm missing something WORKDAYS and
NETWORKDAYS will not work because Saturday is considered a workday.
I came up with a UDF that works fine for two dates that are less than a week
apart using some information from C Pearson's website. Then I realized that
although it doesn't happen often I still need to allow for dates that will
span more than a week such that they could have multiple Sundays and Holidays
in them. That is where I'm stumped.
I'm not locked in to using a UDF if there is a worksheet formula that will
work.
Does anybody know how I would do this?
Thanks
Mike
days between two dates. Unless I'm missing something WORKDAYS and
NETWORKDAYS will not work because Saturday is considered a workday.
I came up with a UDF that works fine for two dates that are less than a week
apart using some information from C Pearson's website. Then I realized that
although it doesn't happen often I still need to allow for dates that will
span more than a week such that they could have multiple Sundays and Holidays
in them. That is where I'm stumped.
I'm not locked in to using a UDF if there is a worksheet formula that will
work.
Does anybody know how I would do this?
Thanks
Mike