Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating new date by entering number of additional workdays
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
|
|||
|
|||
Calculating new date by entering number of additional workdays
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 | |
|
|
Similar Threads | ||||
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 |