View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 27-May-2007 is a WORKDAY?

According to your formula you are looking to return the workday that is zero
days before/after the referenced date. In my version of Excel, that formula
always returns the referenced date (ignoring holidays completely).

If you're trying to determine if the referenced date is a holiday or weekend
try these:

=NETWORKDAYS(DATE(2007,5,27),DATE(2007,5,27),holid ays)=1
or
=AND(WEEKDAY(DATE(2007,5,27),2)<6,COUNTIF(holidays ,DATE(2007,5,27))=0)

(In that example, the formulas return FALSE)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

I'm using the following formula in local Excel 07 and Excel Web
Services, with the same unexpected results.

=WORKDAY(DATE(2007,5,27),0,holidays)

it returns the following.

27-May-2007

Sunday, May 27, 2007, is a workday? I think not.

It has worked fine, and still does, for a spread of dates before and
after, but just not on this one...any ideas?

-- MM