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

Mike,

Thanks for all of your help. It worked perfectly.
Cheers
Kristina


Mike H wrote:
Hi,

You need the workday formula. With your start date June 1 2009 in a1 try this

=WORKDAY(A1,5,Holidays)

Holidays is a named range that contain holiday dates. You can then reference
the cell with this formula in in the same way to get your next milestone.

Mike

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

[quoted text clipped - 16 lines]

Any help is greatly appreciated