MIN Date not working

Kavs

Hello,

I was trying to create a formula to show the MIN date in column on another sheet. I put =MIN({Referenced sheet and column}) and got #invalid column value. Would greatly appreciate the help - seems like it should be a straightforward formula.

Bhupi

I am facing this same issue. Did we get this resolved?

Genevieve P.

Hi @Bhupi and @Kavs

You'll both want to make sure that the column you're entering the formula into is also a Date type of column (otherwise it won't be able to display a Date).

Let me know if this resolved the issue!

Cheers,

Genevieve