Hi,

I have a forumula that currently it looks at cell J9, decides if it is a criteria says EAD or EFM, and then if EAD calculates 30 working days, if EFM counts 30 calendar days and gives me the date.

This is my current formula,=CHOOSE(MATCH(J9,{"EFM","EAD"},0),J11+30,WORKDAY(J11,30))

I need to amend this formula so that it does not include the list of bank holidays I have in a sheet called "Bank Holidays" in column A.

Do you know what the formula should be amended to?

Thanks

Nath'