Help with If/And function
Trying to calculate the age of a closed item and getting errors with the below formula. The objective is to calculate how long it took for an item to close (filtering on Closed items only). Thanks
=IF(AND(I68=”Closed”),M68<>””,M68-Q68,TODAY()-Q68)
Trying to calculate the age of a closed item and getting errors with the below formula. The objective is to calculate how long it took for an item to close (filtering on Closed items only). Thanks =IF(AND(I68=”Closed”),M68<>””,M68-Q68,TODAY()-Q68) Read More