Forum Discussion
Counting the days between values if another row has a specific value(text
Hey guys, I'm looking to count the total amount of days between a lot of dates. but only if in another column a certain value is given. For example A 1-12-2020 31-06-2021 B 1-03-2021 5-05...
=SUMIFS(C:C,A:A,"=A")-SUMIFS(B:B,A:A,"=A")
By the way, the example 31-06-2021 is not a correct date. Maybe that will cause error also.
By the way, the example 31-06-2021 is not a correct date. Maybe that will cause error also.
Somehow this solution doesn't work for me, but I've solved it by using an extra step. Thanks for your time:)