Count Day Between IF

strobn · 03/21/23

I am looking to count the days between two columns, if a third column meets criteria.

Compare Due Date and Collection Date, counting the days between if Test Type is "Random"

Paul Newcome · 03/21/23

Try something like this:

=IF([Test Type]@row = "Random", [Due Date]@row - [Collection Date]@row)

Paul Newcome · 03/21/23

Try something like this:

=IF([Test Type]@row = "Random", [Due Date]@row - [Collection Date]@row)

strobn · 03/22/23

Thank you for the response. Perfect!!

Paul Newcome · 03/22/23

Happy to help. 👍️

Best Answer