First add business days to a date (excluding weekends and holidays), then add regular days

Firstly, welcome to the forum.

WORKDAY is the function you need. You will need to list the federal holiday dates in a contiguous range of cells to start with. Assuming the date you want to add the days to (25 March 2014 in your example) is in cell A2 you need this formula

Formula:

Please Login or Register  to view this content.

Hope that helps.

I'm not sure about your example. You say you want to add 5 working days to 4/2/14. The result should be 4/9/14. If this is what you want, here's the formula:
Assuming 4/2/14 is in cell A1 and 5 is in cell B1, the formula in cell C1 would be =WORKDAY(A1,B1). If you are always adding 5 working days then you can remove the B1 in the formula and manually enter 5.

As for the last part of your question, as Excel treats dates as whole numbers to add 5 days to a date simply add +5 to the end.

Formula:

Please Login or Register  to view this content.

Thank you all for the prompt reply.

gak67's formula: =WORKDAY(A2,5,[range of cells containing federal holidays])

Worked like a charm! Thanks again!