I am using a formula to find the average number of days between two dates across multiple columns. To Further validate this data, I would like to limit the time span which it looks back on. I would like to limit it to looking back across the last 120 days or so. Here is the Formula I am currently using:
=SUMIF(V2:V356,"<100",V2:V356)/COUNTIF(V2:V356,"<100")
Any help is appreciated.
=SUMIF(V2:V356,"<100",V2:V356)/COUNTIF(V2:V356,"<100")
Any help is appreciated.