Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding workdays as part of the equation
I'm trying to put together a simple schedule in Excel and need to calculate
x working days from a given date. So if cell A1 = the project start date, and I need the date in B1 to show the completion date of 13 working days later, is it possible to do that without having to have a seperate cell containg the # of workdays? Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding workdays as part of the equation
Hi David
Provided you have the Analysis Toolpak loaded, ToolsAddinscheck Analysis Toolpak, then =WORKDAY(A1,13) will give your result. If you want to include holidays, then =WORKDAY(A1,13,$B$1:$B$12) where B1:B12 holds a list of holiday dates or create a named range for the holiday dates (holidays)and use =WORKDAY(A1,13,holidays) -- Regards Roger Govier "DavidJ726" wrote in message ... I'm trying to put together a simple schedule in Excel and need to calculate x working days from a given date. So if cell A1 = the project start date, and I need the date in B1 to show the completion date of 13 working days later, is it possible to do that without having to have a seperate cell containg the # of workdays? Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding workdays as part of the equation
Thanks Roger,
Exactly what I needed! "Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ... Hi David Provided you have the Analysis Toolpak loaded, ToolsAddinscheck Analysis Toolpak, then =WORKDAY(A1,13) will give your result. If you want to include holidays, then =WORKDAY(A1,13,$B$1:$B$12) where B1:B12 holds a list of holiday dates or create a named range for the holiday dates (holidays)and use =WORKDAY(A1,13,holidays) -- Regards Roger Govier "DavidJ726" wrote in message ... I'm trying to put together a simple schedule in Excel and need to calculate x working days from a given date. So if cell A1 = the project start date, and I need the date in B1 to show the completion date of 13 working days later, is it possible to do that without having to have a seperate cell containg the # of workdays? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Number of Workdays to a Date (Projects) | Excel Discussion (Misc queries) | |||
shortening an equation, adding increments of a range.. | Excel Discussion (Misc queries) | |||
Please Help: Adding an equation to a range | Excel Worksheet Functions | |||
Adding another field if the equation = True | Excel Discussion (Misc queries) | |||
Adding a number to a date as workdays | Excel Worksheet Functions |