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
|