I have a Google sheet where I would like a score based on a rolling year figure.
I have managed to do these separately using the formulas:
=query(A2:B," where A >= date '"&TEXT(today()-E1,"yyyy-mm-dd")&"' and A <= date '"&TEXT(today(),"yyyy-mm-dd")&"' ")
However, I was wondering if there was a way these two could be combined so I just get the score.
Here is a demo sheet.