Forum Discussion
Solved
Value fall between dates? Looking retrospectively
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?
For 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)
5 Replies
For 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)- Thanks Sergei! Always looks so simple once it's laid out. Works a charm!
tsaurus , you are welcome
- Thanks Kodipady 🙂 was my first post but will definitely keep it in mind for any future posts!
