Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it.
I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more than two days (two working days, Mon-Fri). Essentially it is just counting the number of times a two day deadline is exceeded.
Any thoughts would be appreciated. Thanks!
Help Article Resources
Check out the Formula Handbook template!