Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

**HarvardMajesty** · 01-29-2016, 11:36 PM

The MIN function doesn't work if any of the cells do not have a date. They default to 1/0/1900. Using conditional formulas got too complex and didn't give me results. Below depicts what I'm trying to do. Column A links to dates in another column D. But not every cell in the linked column has dates. So if column D's cell is blank, column A interprets that as 1/0/1900. I need the earliest date of the 4 dates in column A (which is linked to column D) but excluding any 1/0/1900, or, say, dates prior to 1/1/2010. I don't know if 1/0/1900 is not a real date (the column is defined as dates), if it's a null value, or how it is interpreted.

Row/Column A B C D
Linked Date Date Name Original Date
3 1/0/1900 date1
4 7/14/2016 date2 7/14/2016
5 12/4/2014 date3 12/4/2014
6 1/0/1900 date4

1/0/1900 minimum date of date1-4 BUT I WANT A DATE > 2/1/2010
What formula will give me the minimum date of dates > 2/1/2010?

**sourabhg98** · 01-30-2016, 01:31 AM

Why don't you refer to Column E directly-
=MIN(E3:E6)

**shukla.ankur281190** · 01-30-2016, 02:00 AM

Or

Try

=MIN(IF(B3:B6>=DATE(YEAR(1990),MONTH(1),DAY(0)),B3:B6)) with CRTL+SHIFT+ENTER.

**hemesh** · 01-30-2016, 02:28 AM

try below in D3 and Drag down
=IF(B3>2/1/2010,B3,"") this will give you original dates then you can use min formula as =MIN(E3:E6)

if you want dates min date in a single cell greater than 2/1/2010 then you can use
=MIN(IF((B3:B6>2/1/2010),(B3:B6)))

format the cells as DD-MM-YYYY or the format you want

**samba_ravi** · 01-30-2016, 02:38 AM

or try

Please Login or Register  to view this content.

Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

LinkBack

Thread Tools

Rate This Thread

Display

Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

Re: Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

Re: Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

Re: Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

Re: Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.

Thread Information

Users Browsing this Thread

Similar Threads

If month and year of a date in a range of dates matches a specific date, return true

Match year of date to year of date specific range of dates, output corresponding value.

[SOLVED] Lookup for the succeeding dates after the earliest date

[SOLVED] Date filter for specific dates

Pick the earliest date from a selection of dates...

How do I find the earliest dates in a range of dates?

Find the earliest date in a range of dates?

Bookmarks

Bookmarks

Posting Permissions