Calculating days

[davidingilbert]

Hello Folks -

I am actually in need of two formulas for the same project I am working on at my job regarding delivery of a time sensitive document in relation to the end of a transaction.

What I am trying to do is set up my spreadsheet so that when the time sensitive document is delivered to the customer, two other fields will automatically populate with the dates (as specified by the two requests below). From there we can determine if we are meeting the proper timing in this situation or not.

The two types of formulas I am looking for are:

1. An excel formula that will calculate 3 business days between the delivery of the document to the customer and the end of the transaction. This formula must be able exclude Sundays and the 10 federal holidays for 2014.

2. An excel formula that will calculate 3 business days between the delivery of the document to the customer and the end of the transaction. But this formula must be able to exclude Saturdays, Sunday, the 10 federal holidays for 2014 and any other days that my company is closed.

I know there is an array formula I can use. I posted something a few years ago looking for something similar. Problem is, when I try and use it, I am getting an error message or two and I no longer have access to the spreadsheet I used at my previous company where the similar formula was used.

Thank you for your help.
Dave

[hoyasaxa215]

The function below should assist in achieving your desired results.

http://office.microsoft.com/en-us/ex...in=HP010342656

[davidingilbert]

Hoya - I will give it a try. Never used "networkdays.intl" before. Will keep you posted.
Thanks.
Dave

[davidingilbert]

Let me ask this -
is there a way of achieving the same thing, but using a formula with an array situation - such as this formula....
=MIN(IF(WEEKDAY(A1+B1+{0,1,2,3,4})<>1,IF(ISNA(MATCH(A1+B1+{0,1,2,3,4},H$1:H$10,0)),A1+B1+{0,1,2,3,4})))

Based on the way the project is going, it may be easier in a way if I could use the above formula.