Skip to Content
0
Former Member
Jul 21, 2016 at 01:19 AM

Min date in a column based on the number

51 Views

Hi all,

I am trying to display the minimum date on the column B where there is Available slots > 5.

But I am not able to get it right.

For example, for the row 123, the minimum date should display as 25/7/16

The formula in column B is

=Min([Appoint date]) where ([Available slots]>5)

Formula in C is:

If([Available slots]>5; Min([Appoint date]);[Available slots])

Any help or guidance much appreciated.

Thanks,

Ramya

Attachments