Hi all,
I am wondering how can I get the end date of a project if i have the
starting date, the workdays that it will need, the fact that a week
have 5 working days and a list of hollydays?

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 and automatically get the
end date. which will therefore be, StartDay+HollyDays+WeekEnd
+WorkDays, all these add up together to the EndDay.

sample data:

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


and the hollydays are in the form DD - MM (year - independant)


DD MM
12 01
11 02
3 03
25 04
22 07
1 09
2 11
21 11
31 12


How should i approach such a problem?

Thanks