Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
=IF(J3<>"Weekend","Weekday",IF($Z3="","No NADM",IF(OR(AA3<=$L3,$O3<=Z3,AA3-Z3<0.084),"NA Does Not Apply",IF(AND((TEXT(WEEKDAY(L3),"ddd"))="Sat",Z3<=($L3+0.084),AA3>=((INT($L3)+2+'Ref Data'!$B$2))),"Yes",IF(AND((TEXT(WEEKDAY(L3),"ddd"))="Sun",Z3<=($L3+0.084),AA3>=((INT($L3)+1+'Ref Data'!$B$2))),"Yes","No")))))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|converting excel into labels||6||36|
|manual process automation||5||47|
|how can I determine if an Excel spreadsheet will fit on an 8.5 by 11 inch sheet?||3||59|
|Paste Table from Excel VBA to the PowerPoint 2010||18||50|
Join the community of 500,000 technology professionals and ask your questions.