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 ...
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)
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.
Thanks Kodipady 🙂 was my first post but will definitely keep it in mind for any future posts!