| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate End Date (excluding weekends and holidays)
Hello,
I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
In article ,
guitaronmyback wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you Have a look at the WORKDAY function... -- Domenic http://www.xl-central.com |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
Hi,
Try this =WORKDAY(B1,25,Holidays) Where B1=start date 25 is the days for the project Holidays is a named range containing holoiday dates. Mike "guitaronmyback" wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
Thank you for the tip, but I got the #name? as a result
"Mike H" wrote: Hi, Try this =WORKDAY(B1,25,Holidays) Where B1=start date 25 is the days for the project Holidays is a named range containing holoiday dates. Mike "guitaronmyback" wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
The WORKDAY function requires the Analysis ToolPak add-in to be loaded.
Click Tools/Add-Ins from Excel's menu bar and put a check mark next to the Analysis ToolPak item. -- Rick (MVP - Excel) "guitaronmyback" wrote in message ... Thank you for the tip, but I got the #name? as a result "Mike H" wrote: Hi, Try this =WORKDAY(B1,25,Holidays) Where B1=start date 25 is the days for the project Holidays is a named range containing holoiday dates. Mike "guitaronmyback" wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
It worked, but it seemed to add an extra day....10 workdays, starts on a
Monday and the final date was a Monday, when it should be a Friday....any way of fixing that? "Rick Rothstein" wrote: The WORKDAY function requires the Analysis ToolPak add-in to be loaded. Click Tools/Add-Ins from Excel's menu bar and put a check mark next to the Analysis ToolPak item. -- Rick (MVP - Excel) "guitaronmyback" wrote in message ... Thank you for the tip, but I got the #name? as a result "Mike H" wrote: Hi, Try this =WORKDAY(B1,25,Holidays) Where B1=start date 25 is the days for the project Holidays is a named range containing holoiday dates. Mike "guitaronmyback" wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate End Date (excluding weekends and holidays)
Subtract 1... the difference is because you are thinking "counting numbers"
as opposed to "subtraction of two numbers"... 1, 2, 3, 4 5 is five counting numbers but the difference between 1 and 5 is four. -- Rick (MVP - Excel) "guitaronmyback" wrote in message ... It worked, but it seemed to add an extra day....10 workdays, starts on a Monday and the final date was a Monday, when it should be a Friday....any way of fixing that? "Rick Rothstein" wrote: The WORKDAY function requires the Analysis ToolPak add-in to be loaded. Click Tools/Add-Ins from Excel's menu bar and put a check mark next to the Analysis ToolPak item. -- Rick (MVP - Excel) "guitaronmyback" wrote in message ... Thank you for the tip, but I got the #name? as a result "Mike H" wrote: Hi, Try this =WORKDAY(B1,25,Holidays) Where B1=start date 25 is the days for the project Holidays is a named range containing holoiday dates. Mike "guitaronmyback" wrote: Hello, I have a start days and a number (representing days for a given project). I want to calculate the end date and exclude weekends and certain holidays. Is this possible? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Date/Time Difference Excluding Weekends & Holidays | Excel Worksheet Functions | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
Linear Mode
