"=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?

"=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?

"=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?

"=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?

"=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?

"=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?

"=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?