| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Workdays"
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Workdays"
=WORKDAY(A1,C1) you will need to have the analysis tool pak installed as an addin Greetings from NZ Bill K "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
