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