Another workday problem

[ndello]

If I have C15=7/4/03 and in H2:H6000 I have a list of dates called holiday.

In B15 If c15=the holiday list, then use the workday formula. If c15 doesn't match the holiday list then show "".

Here is my formula which isn't working: The workday is fine, but the blank cell never happens!

=IF(MATCH(C16,H2:H6000,TRUE),WORKDAY(C16,G10,'Notice Date Calculator.xls'!NewYork),"")

Thank you
Neil

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(MATCH(C16,$H$2:$H$6000,1)),WORKDAY(C16,G10,'Notice Date Calculator.xls'!NewYork),"")

 

[Dave Patton]

Neil

Workday can identify Holidays from a range as illustrated in suggestions in your previous threads.

Excel's HELP has information on the function.

 

[ndello]

Thank you.
I tried the help function and the function wizard but couldn't figure it out.

Thanks again
Neil

 

[Joe4]

Did you figure this out yet?

The format of Workday is WORKDAY(start_date,days,holidays)
The format of NetWorkday is NETWORKDAYS(start_date,end_date,holidays)

You need the Analysis Took Pak installed to use both of them.

For the holidays, if you entered you holidays (in date format) in column A from A1:A10, then in the function, simply substitute A1:A10 in where it asks for the holidays.

 

[IML]

=IF(MATCH(C16,H2:H6000,TRUE),WORKDAY(C16,G10,'Notice Date Calculator.xls'!NewYork),"")

I'm late here, but
ISNUMBER(MATCH(A1,H1:H6000,1)) or
ISNUMBER(MATCH(A1,H1:H6000,True))
will only return false if A1 is less that H1 and H1:H6000 is sorted.

If your goal to check if A1 is contained within the list exactly,change your logical test in the if statement to
ISNUMBER(MATCH(A1,H1:H6000,0)) or
ISNUMBER(MATCH(A1,H1:H6000,False))
H1:H6000 does not need to be sorted in this case.