Min/Max Date functions

Nyasha

Please help - I'm trying to pick the smallest date from this range: 07/18/22, 07/20/22, 07/08/22, 07/14/22, 07/20/22 using the command =MIN(C1@row:C5@row) but I'm drawing a blank.

Thanks in advance.

Andrée Starå

Hi @Nyasha

I hope you're well and safe!

It should work. What happens?

Ensure that all columns are date columns.

Did that solve it?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Nyasha

I hope you're well and safe!

It should work. What happens?

Ensure that all columns are date columns.

Did that solve it?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nyasha

Hey Andree - yes that was the problem. The columns were not Date format.

Many thanks!😎

Good day.

Andrée Starå

@Nyasha

Excellent!

Happy to help!