Aug 19 2019 07:08 PM
Hi!
I have a sheet that includes in each row, a start date cell and a finish date cell. Third cell per row I've got happily set up to tell me the working day difference between the start and finish date (or TODAY if unfinished).
How can I set up something like a COUNTIF to show me how many unfinished items there were on a particular day, and then how many working days each item had been open for on that particular day?
Aug 19 2019 08:50 PM
Would you be able share a sample worksheet with some example data points and expected result ? That will help you and contributors here to get a quicker and better solution for you.
Aug 20 2019 03:59 AM
SolutionFor such sample
that could be like
Unfinished tasks
=COUNTIFS(B:B,">"&$G$2,A:A,"<="&$G$2)
Workdays opened on that date
=IF( (A2<=$G$2)*(B2>=$G$2),NETWORKDAYS(A2,MIN(B2,$G$2)),0)
Aug 21 2019 07:19 PM
Aug 21 2019 07:19 PM
Aug 22 2019 02:46 PM
@tsaurus , you are welcome
Aug 20 2019 03:59 AM
SolutionFor such sample
that could be like
Unfinished tasks
=COUNTIFS(B:B,">"&$G$2,A:A,"<="&$G$2)
Workdays opened on that date
=IF( (A2<=$G$2)*(B2>=$G$2),NETWORKDAYS(A2,MIN(B2,$G$2)),0)