Hi all,
I am wondering how can I get the end date of project if i have the
starting date, the workdays that it will need, the fact that a week
have 5 working day and a list of holidays?
the problem is that in B:B i have many projects each starting in a
different date, some in 2008 some in 2009, i imported to C:C the
working days now in D:D and i have the hollydays in format "dd-mm"
independent of the year, so now what should i do to get the end day?
including the weekends and if any date from the hollydays, happen to
be after the starting date of the project.
sample data:

Start date Work days
05.21.2008 9
11.05.2008 124
12.28.2008 35
02.07.2009 114

and the hollyday are the form(year - independant)

DD MM
12 1
11 2
3 3
25 4
22 7
1 9
2 11
21 11
31 12

How should i approach such a problem?
Thanks