Formula question

[ovadeso]

Is there a formula that will look at a range of dates and return the earliest or latest date? I would appreciate your help on this. Thanks from,
ovadeso.

 

[Dimli]

Try using the MIN and the MAX function with the range of cells containing the dates.

 

[ovadeso]

I tried MIN/MAX function but it seems to restrict the size of the range to 30 rows. Is there a work-around for that?

 

[rs2k]

To return the earliest (miniumum) date use
=MIN(IF(List<>0,List,FALSE))
To return the latest (maximum) date use
=MAX(IF(List<>0,List,FALSE))

Note: List, means your range eg, A1:A10

Also, these are array formulas and need to be entered with Ctrl+Shift+Enter

Colin.

 

[Aladin Akyurek]

I tried MIN/MAX function but it seems to restrict the size of the range to 30 rows. Is there a work-around for that?

=MIN(Range)

=MAX(Range)

where Range can be something like B2:B100, F2:N2, or C:C.

 

[ovadeso]

Thanks Colin. Problem solved.

 

[Aladin Akyurek]

Thanks Colin. Problem solved.

No array formulas are needed for the task you describe.