Then I'd probably recommend going with Dave Peterson's solution. The
Workdays() function allows you to set up a list of dates in your workbook
that are to be considered non-workdays (i.e. holidays) along with Saturdays
and Sundays. You'd just have to build that list.

The other option would be if you can give me a list of all holidays to be
considered and the rule(s) that go with them, or point me to a NZ website
that gives that kind of information, I could probably modify the holiday
finding code to work with NZ holidays. If you want to try to go that way, my
email is (remove spaces):
HelpFrom @ JLathamsite.com


"Silena K-K" wrote:

Hi Dave & JLatham

Thanks for your suggestion Dave.

For JLatham - I'm in New Zealand. As far as I am aware most of the
'state/public' holidays are on a set day not date excluding Christmas and New
Year. If either the 25th or 26th Dec / 1st or 2nd Jan fall on a weekend we
get the next two business days off.

Any suggestions? Thanks again, Silena


"JLatham" wrote:

My first question: whose holidays? United States, Brazil, Canada? Deciding
what's a weekend day is fairly easily, but holidays can toss in a curve -
especially when you have situation like in the U.S. where if a federal
holiday falls on a Saturday, it's observed on Friday and if it falls on
Sunday, then it's observed on Monday.

I've actually got stuff available now to determine when U.S. Federal
holidays are observed that could be worked into a solution for your
situation, but for holidays elsewhere, it would no doubt take some
modification. Individual additional holidays, such as those observed by the
various states in the U.S. would also have to be given consideration.


"Silena K-K" wrote:

Hi there

I want to generate an End date by adding together a start date and a
duration - one of 30 days (including weekends and holidays) and one of 30
working days (business days only)

Eg: if my start date is 30 Jun 08 what is the finish date after 30 working
days
if my start date is 30 Jun 08 what is the finish date after 30 days

Thanks for your help, Silena