I need to calculate the minimum date between a cell and TODAY, but somehow the MIN function is failing me. Here's the demonstration.
If I calculate it on a range, such as
=min(A1:A2) it works, but I need to do it inline, I don't have a range to check. If I try to calculate it on comma separated values, it returns an integer
I'm puzzled, what am I missing?