I am getting an Error while using this formula..
LARGE(IF(ISNA(MATCH(FD_RD_EndDt-ROW(INDIRECT("1:10"))+1,Holidays,0)),IF(TEXT(FD_RD_EndDt-ROW(INDIRECT("1:10"))+1,"ddd")<>"Sun",FD_RD_EndDt-ROW(INDIRECT("1:10"))+1)),1)
where FD_RD_EndDt= 14-Aug-2010
Holidays:
26-Jan-10
12-Feb-10
19-Feb-10
27-Feb-10
01-Mar-10
16-Mar-10
24-Mar-10
28-Mar-10
01-Apr-10
02-Apr-10
14-Apr-10
01-May-10
27-May-10
15-Aug-10
19-Aug-10
10-Sep-10
11-Sep-10
30-Sep-10
02-Oct-10
17-Oct-10
05-Nov-10
07-Nov-10
17-Nov-10
21-Nov-10
17-Dec-10
25-Dec-10
This formula is used in the 14th ROW..
I am getting a ZERO value only in this case...
So please advise whats the error..
Regards
e4excel
Bookmarks