I'm not sure precisely how to work this in - but you can use the
=workday(a,b,c) function in the analysis tookpak to help with this (there is
also a vba version)

a = start date
b = number of working days to count
c = range with a list of holidays (or the list itself I guess).
this will avoid weekends as well as the list of holidays.
haven't thought it out on how to use this - this function is also available
to a VBA routine - however I'm not sure how to get one add-in to call a
routien in another add-in - I have a question pending on that myself - hope
this helps


"Nigel" wrote:

Is there any way to determine the last working day of a month by using code

Thanks