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

I developing a small project plan in excel - starting with project end date
and subtracting task durations to get to start date. Using
=DATE(YEAR(D30),MONTH(D30),DAY(D30)-C29) to get to the next earlier date.
Problem is I need to exclude weekend dates. D30=end date. C29=duration of
task. How do I do that?