Using NETWORKDAYS within a SUMIF

[jlaessig]

Hello!
I am trying to write logic for determine the number of items with a due date of tomorrow. Right now, I am using the following formula :
=SUMIFS(Data!AJ:AJ,Data!Z:Z,"Future Due",Data!Y:Y,Data!$AL$1+1)
where column AJ is just a count of 1, Z indicates if the due date is in the future, Y is the particular due date for that row item, and AL1 is today's date.

It is working fine, except when I am trying to see what is due "tomorrow" on a Friday, which would of course be a Monday (or $AL$1+3). Does anyone have any ideas on how to rewrite this so the +1 (basically, tomorrow) exclude weekends/holidays?

Any help is greatly appreciated!!

Jessica

 

[Phuoc]

Change: $AL$1+1

to: =WORKDAY($AL$1,1)

 

[jlaessig]

Works perfectly! Thank you!!