Formula question

ovadeso

Board Regular
Joined
Sep 23, 2004
Messages
150
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Dimli

Board Regular
Joined
Oct 15, 2004
Messages
109
Try using the MIN and the MAX function with the range of cells containing the dates.
 

ovadeso

Board Regular
Joined
Sep 23, 2004
Messages
150
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

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209

ADVERTISEMENT

ovadeso said:
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.
 

Forum statistics

Threads
1,147,665
Messages
5,742,500
Members
423,733
Latest member
hamann666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top