# Need help to find oldest and latest date

#### psdileep

##### New Member
I've data in two columns as below and I need formula to get latest and oldest date as below:

1) Find oldest date from columns having data in both Col 1 and Col 2
2) Find newest date from columns having only date in Col 2

Col 1 Col 2
A 2014-03-19
B 2014-03-19
C 2014-03-19
D 2014-03-19
E 2014-03-19
F 2014-08-28
A 2014-08-28
B 2014-08-28
C 2014-08-28
D 2014-08-28
E 2014-08-28
F 2014-08-28
2014-08-28
2014-08-28
2014-08-28
2014-08-28
2014-08-27
2014-08-27

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Does this do what you want?

If using Excel 2010 or later you can use the col F formulas, otherwise use col G formulas which must be confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}

Excel Workbook
ABCDEFG
1Col 1Col 2
2A2014-03-19Oldest with 22014-03-192014-03-19
4C2014-03-19
5D2014-03-19
6E2014-03-19
7F2014-08-28
8A2014-08-28
9B2014-08-28
10C2014-08-28
11D2014-08-28
12E2014-08-28
13F2014-08-28
142014-08-28
152014-08-28
162014-08-28
172014-08-28
182014-08-27
192014-08-27
20
Dates

My problem is that data changes every day and I modified given formula to like this: {=MIN(IF(Sheet2!F2:F2000<>"",Sheet2!I2:I2000))}

However, value returned is 1900-01-00

Can you help me with some generic formula and should work even if data varies.

<tbody>
</tbody>

My problem is that data changes every day and I modified given formula to like this: {=MIN(IF(Sheet2!F2:F2000<>"",Sheet2!I2:I2000))}

However, value returned is 1900-01-00

Can you help me with some generic formula and should work even if data varies.
Still confirmed with C+S+E

=MIN(IF(F2:F2000<>"",IF(I2:I2000<>"",I2:I2000)))

Thanks Peter. It worked like a charm.

Thanks Peter. It worked like a charm.
That's good, thanks for letting us know.

Replies
10
Views
225
Replies
6
Views
170
Replies
6
Views
205
Replies
2
Views
112
Replies
3
Views
436

1,221,058
Messages
6,157,667
Members
451,431
Latest member
gdekker

### 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.

### Which adblocker are you using?

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

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