"=WORKDAY" PROBLEM

[Gator Girl]

$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?

 

[Castell]

Change the 1 to a 0.

 

[BoniM]

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]

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?

 

[Gator Girl]

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?

 

[Gator Girl]

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]

You're welcome, happy I could help!

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.