TRandolph’s Profile

Community member since May 2019



Hello all,

I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references.

I am having trouble getting this to work when using a range of items. When I use the COUNTIFS