Date input query
I have a module with various bank loans and maturities e.g. 2020-2028 - this is dimensioned by quarters.
I want to create a module that sums up the total bank loans by maturity. I've used a formula YEAR to extract the maturity year, but I can't seem to be able to sum on this year?
Can anyone assist?