Return MIN date from another sheet if criteria are met

Sam Swain

Hello community!

I am trying to return a date value from another sheet if criteria are met.

TIME SHEET

The date on the first row uses this formula:

=DATEONLY(MIN({StartDate})) + ""

It is pulling this information from the PROJECT PLAN SHEET start date column:

I need the formula in the highlighted cell of the TIME SHEET to return the MIN date from the 'Start Date' column in PROJECT PLAN SHEET if it is part of the feasibility section.

Is it a combination of DATEONLY(MIN for the date and also INDEX(MATCH for the word "Feasibility"?

THANK YOU IN ADVANCE!

Regards,

Sam

Sam Swain

SOLUTION

=INDEX({StartDate}, MATCH(Project@row, {Item}, 0)) + ""

Then change column type to date to avoid formula returning the hour and minute.