I'm not intuitive enough to figure out how to add this in, and Googling and searching existing threads in various Excel forums (including this one) didn't answer my question.

Here's my existing formula: =IF(LEN(J1790)=0,INT(K1790-NOW()),"") Where Column J is the date received for Document B and Column K is the required due date for Document B.


It was written by our IT guy, but he works off-site and we don't see him that often, besides, it's good for me to understand these things myself (at least a little). At any rate, the formula does a fabulous job of determining when document A was submitted, and if document B is submitted in 21 days or under of Document A. Unfortunately, it doesn't take into consideration weekends and holidays, and so it can appear as if the vendors are late, when really they aren't.

Thanks in advance!