If Statement with AND Statement Help

[Grahar]

Hi, 

Could anyone help me with the case below"

Employee	Years Worked	Start Date
John	09-01-2006	XX
John	09-01-2007	XX
John	09-01-2008	XX
John	09-01-2009	XX
Mary	03-01-2012	XX
Mary	03-01-2013	XX
Mary	03-01-2014	XX

I wanted to use a formula so that the "Start Date" column populated the earliest date from the "Years Worked" column for each employee (i.e. for John, all "Start Date" row values would equal 09-01-2006. For Mary, it would equal 03-01-2012).

Thanks in advance!

[rzdodson]

@Grahar see attached. Let me know if that is what you are looking for.

[Grahar]

I am unable to open the attached file- could you post screenshots?

[Grahar]

Nevermind your screenshot just loaded for me!

[Grahar]

Could you post screenshots of the formulas used?

[nli]

This should work. I solved so that Start Date is the same format as the Years Worked column. If this helps, please mark as solution.

[cjaneczko]

[rzdodson]

@Grahar these are the screenshots you requested.

[caltang]

Like so:

@Grahar If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[flying008]

Hi, @Grahar 

FYI.

Input			Output
Employee	Years Worked		Employee	Years Worked	Start Date
John	09-01-2006		John	09-01-2006	09-01-2006
John	09-01-2007		John	09-01-2007	09-01-2006
John	09-01-2008		John	09-01-2008	09-01-2006
John	09-01-2009		John	09-01-2009	09-01-2006
Mary	03-01-2012		Mary	03-01-2012	03-01-2012
Mary	03-01-2013		Mary	03-01-2013	03-01-2012
Mary	03-01-2014		Mary	03-01-2014	03-01-2012