One of columns is DATE. I would like to create another column COMMENT and there include text:
“Range from MIN(DATE) - MAX(DATE)”.
MIN(DATE) would be the oldest date in the column DATE.
MAX(DATE) would be the most recent date in the column DATE.
Then I would use a Summary function to total a value in another column, e.g. column FEES.
All I am looking for is to see table something like this… Col 1 is COMMENT and Col 2 is FEES.
COMMENT: ____________________________________________ FEES
Range from 1.4.2022 - 31.03.2023 ________________ 3999
I tried Fill function but that only works if the adjacent cells are empty. I tried various Max Min formulas but they don’t work on dates. I looked in the daytime formula if there is a way to convert the date to a universal time number so that I can use Min Max and then convert it back to time, but no, no such function.