Formula for 3 days prior excluding weekends and holidays

[Thunderer]

I'm working with this formula but I keep getting the dreaded #VALUE!. I need to validate whether the date in Column J is <= 3 days prior to today, minus holidays and weekends.

=IF(NETWORKDAYS(J2<=TODAY()-300, J2<=TODAY()-3,Q1:Q12),"Y","N")

Q1:Q12 is the range of my holidays which I have formatted as 1-Jan, 25-Dec, etc.

Column J is formatted as 1/7/2014 7:26

I set the networkdays as anywhere between 300days prior to today and 3 days prior to today.

Can anyone help?

Respectfully,

Tim

 

[btomjack]

Try this:

=IF(3>=(NETWORKDAYS(J2,TODAY(),Q1:Q12)),"Y","N")

When you're embedding one function inside another, it is helpful to start with the innermost function (NETWORKDAYS in this case) and compute that in a separate cell. Once you have that function calculating correctly, copy the text and paste it into the outer function; this saves a lot of mess and frustration trying to figure out which function is causing the problem.