I have a column that is multiple select, in which I enter dates in the format mm/dd/yy, to keep track of when I bought things. So let’s say for Cinnamon, the History column might have dates 02/20/19 and 03/01/19 as multiple select entries.
I am trying to:
- Have another column displaying the most recent date from that History column
- Have another column displaying a number value that is the difference between that most recent date, and today (example for Cinnamon above, most recent date is 03/01/19, so today being 03/11/19, that would be 10 days).
Thank you very much for any help!!