Thread: "Workdays"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default "Workdays"

Is it safe to assume that the duration in Column C is working days, and you want
Column B to be the date that is the number of Column C working days after the
start date?

If so, use the Workday function:

Column B =Workday(a1,c1)

You may need to load the Analysis Toolpak to access this function
(ToolsAddins...)

--
Regards,
Fred


"GNaipaul" wrote in message
...
I have colomn with start date(Column A), Column C = duration Column B =
Column a + Column C

I would like exclude Saturday and Sunday of the week

How can I do That?

Please Help