I don't understand some parts of the formula so pls. bear with me: :)
=IF(COUNTA(N1214)=1,-50000,IF(COUNTA(L1214)=1,-50000,IF(I1214-'Date Now'!A1237<-1,(ROUNDDOWN(I1214-'Date Now'!A1237,0)),(IF(I1214-'Date Now'!A1237<0,ROUNDDOWN(I1214-'Date Now'!A1237,0),(ROUNDUP(I1214-'Date...