I am trying to use a matrix formula to calculate the "days since the last contact" in column U of my sheet. I started with:
= DATEDIF (V60, Today (), "D")
What worked well and entered the number 1 in column U (I'm writing this on 12/7). Then I tried to convert this into a matrix that I put over the row of the frozen heading in column U (#REF in the screenshot). I'm trying:
= ARRAYFORMULA (yes (ISBLANK (V2: V), "", DATEIF (V2, Today (), "D")))
However, the resulting #REF error reads:
The result of the matrix was not expanded because it would overwrite the data in U3. How can I make this work?