Formula to add/subract business days (excluding sundays and federal holidays only)

New to the forum and still learning excel. I have looked everywhere for a simple explanation on how to do this but still can't seem to figure it out. I am attempting to create a spreadsheet for a bank that will make it easier for loan officers to determine which days loan disclosures are required under the soon to be implemented new rules.

I have figured out how to get excel to calculate 3 business days into the future (excluding sat/sun/holiday) fairly easily with a WORKDAY formula.

However, for the closing disclosure, we basically need a formula that will subtract 6 business days from the "closing date" to determine which date the closing disclosure must be mailed. The problem with this one is that the laws include saturday as a workday in this regard which seems to negate the use of a WORKDAY or NETWORKDAYS formula.

Can anyone help? I have seen a similar thread on this but it was about adding days and I still didn't quite understand the formulas provided.

Thanks a lot

Is this function available in your version of excel? If so you could identify Sundays only as weekends.

https://support.office.com/en-us/art...rs=en-US&ad=US

Well I think I finally figured out using this other thread. Maybe I just needed to sleep on it.

http://www.excelforum.com/excel-gene...work-week.html