Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Would love some assistance with the following:
If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell (B1), resulting in a new date -- skipping weekends -- in a third cell (C1). Looking for the formula for C1. If it helps, here's an example: * Start date = 4/1/10 (which is a Thursday) * Additional workdays = 5 * Solution = 4/7/10 (because it skipped the weekend) Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Ensure that you have the Analysis Toolpak loaded. ToolsAddinsAnalysis Toolpak then with startdate in A1, number of days to add in B1 =Workday(A1,B1) Optionally you can include holidays. With a list of holiday adtes in C1:C20 =Workday(A1,B1,$C1:$C20) -- Regards Roger Govier blswes wrote: Would love some assistance with the following: If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell (B1), resulting in a new date -- skipping weekends -- in a third cell (C1). Looking for the formula for C1. If it helps, here's an example: * Start date = 4/1/10 (which is a Thursday) * Additional workdays = 5 * Solution = 4/7/10 (because it skipped the weekend) Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating number of workdays between 2 dates | Excel Worksheet Functions | |||
Adding Number of Workdays to a Date (Projects) | Excel Discussion (Misc queries) | |||
Calculating number of workdays | Excel Worksheet Functions | |||
How do I find total number workdays from a range of date | Excel Worksheet Functions | |||
Adding a number to a date as workdays | Excel Worksheet Functions |