Making a calender to calculate endday of a project in Excel

[mart1n0]

(How) is this possible in Excel?

I have to make a calender of a few years (e.g. a year on each worksheet). In this calender there are special days: saturdays, sundays, days with frost and holidays. I need a function where I can enter a start day for a project and the number of days needed to complete a project.

As output I need the end date for this project, this is the start date + the amount of days needed to finish the project, but the special days do not count as days needed to complete the project. If the days of the project would be highlighted or something like 'project' would be filled in in the correct cells of the calender then this would be a nice extra.

Hope my question is clear enough,
Mart1n0

 

[gizmo1973]

Might not help you at all but what you are trying to do is covered in MS Projects which is a really powerful tool.
If you have it availabe it may be the answer to your problem.

Regards, Phil.

M.U.F.C. Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts