MIN Date Function

Jackuk127

New Member
Joined
Jan 28, 2021
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I am trying to enter a formula which gives me the earliest date from a range of dates and depending upon a certain criteria. If I was to say what I need to achieve it would be:

"If M6:M603 is equal to 1 then look up the earliest date in columns G6:L603 and place that date in another worksheet. Do not count any of the blank G6:L603 dates".

Each time I do the formula using MIN and IF functions it produces the date 00/01/1900.

Can anyone please help?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

Try
Excel Formula:
=AGGREGATE(15,6,G6:L603/((M6:M603=1)*(G6:L603<>"")),1)
 

Watch MrExcel Video

Forum statistics

Threads
1,128,078
Messages
5,628,530
Members
416,323
Latest member
65563

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