Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Schedule/Date Calculation
How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days?? |
#2
|
|||
|
|||
Take a look at WORKDAYS() in XL Help. This is an Analysis Toolpak Add-in
function (Tools/Add-ins...) In article , lkoyne wrote: How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend days?? |
#3
|
|||
|
|||
If the date is in A1, rather than a simple =A1+5
try =A1+5+(WEEKDAY(A1+5)=7)*2+(WEEKDAY(A1+5)=1) -- Gary's Student "JE McGimpsey" wrote: Take a look at WORKDAYS() in XL Help. This is an Analysis Toolpak Add-in function (Tools/Add-ins...) In article , lkoyne wrote: How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend days?? |
#4
|
|||
|
|||
On Tue, 11 Oct 2005 07:40:08 -0700, lkoyne
wrote: How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend days?? Look at HELP for the WORKDAY function. It requires installation of the Analysis Tool Pak. For your example above: A1: 10/11/05 B1: 5 C1: =WORKDAY(A1,B1) := Tuesday, October 18, 2005 You'll need to format C1. Note that the WORKDAY formula has an optional "Holidays" argument where you can specify a range that contains all of the holidays that you don't want to count. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |