View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default "=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?