| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"=WORKDAY" PROBLEM
$Q$4 = FIRST CALENDAR DAY OF MONTH
$BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
Change the 1 to a 0.
"Gator Girl" wrote in message ... $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
Thanks, but I already tried that, then other months don't come up correctly.
Isn't there a formula that will work first time, every time? "Castell" wrote: Change the 1 to a 0. "Gator Girl" wrote in message ... $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
Changing the 1 to a 0 fixes the broken months, but it makes other months have
the wrong start date. Isn't there a formula which will work first time, every time? "Castell" wrote: Change the 1 to a 0. "Gator Girl" wrote in message ... $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
It's the 1 in your second argument... you're asking for the first workday
after the given day, so if the first of the month is the first workday, you're getting the second instead. =WORKDAY($Q$4-1,1,$BW$10:$BW$18) should fix it. "Gator Girl" wrote: $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
It worked! Thank you, Boni!
PS Haven't gotten the hand of this posting stuff yet, I thought nobody saw my post that you responded to - so I posted it again. Please ignore it, and thank you again. "BoniM" wrote: It's the 1 in your second argument... you're asking for the first workday after the given day, so if the first of the month is the first workday, you're getting the second instead. =WORKDAY($Q$4-1,1,$BW$10:$BW$18) should fix it. "Gator Girl" wrote: $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"=WORKDAY" PROBLEM
You're welcome, happy I could help!
"Gator Girl" wrote: It worked! Thank you, Boni! PS Haven't gotten the hand of this posting stuff yet, I thought nobody saw my post that you responded to - so I posted it again. Please ignore it, and thank you again. "BoniM" wrote: It's the 1 in your second argument... you're asking for the first workday after the given day, so if the first of the month is the first workday, you're getting the second instead. =WORKDAY($Q$4-1,1,$BW$10:$BW$18) should fix it. "Gator Girl" wrote: $Q$4 = FIRST CALENDAR DAY OF MONTH $BW$10:$BW$18 = HOLIDAYS Using the formula: =WORKDAY($Q$4,1,$BW$10:$BW$18) I get the first workday of each month, excluding holidays, for some months, but for others, it's moving ahead one more workday. What the heck am i doin' wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
