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?
"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?