Thread: Dates formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kristina1976 Kristina1976 is offline
external usenet poster
 
Posts: 2
Default Dates formula

I need some assistance in creating a formula for dates. What I am trying to
do is create a project time line based on workdays Mon - Fri plus exclude
holidays

I have a start date and a completion date however I need to have specific
tasks completed throughout the project. ie

Start date June 1, 2009

Design June 1st plus 5 days
(this is where I need the formula, again taking into consideration this needs
to be Mon-Fri, & not a holiday)

Print June 5 plus 2 days
(this is where I need the formula, again taking into consideration this needs
to be Mon-Fri, & not a holiday)

End date June 30th, 2009


Any help is greatly appreciated