Hi, Could anyone help me with the case below" EmployeeYears WorkedStart DateJohn 09-01-2006XXJohn09-01-2007XXJohn09-01-2008XXJohn09-01-2009XXMary03-01-2012XXMary03-01-2013XXMary03-01-2014XX 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!

Hi, @Grahar FYI. Input Output EmployeeYears Worked EmployeeYears WorkedStart DateJohn09-01-2006 John09-01-200609-01-2006John09-01-2007 John09-01-200709-01-2006John09-01-2008 John09-01-200809-01-2006John09-01-2009 John09-01-200909-01-2006Mary03-01-2012 Mary03-01-201203-01-2012Mary03-01-2013 Mary03-01-201303-01-2012Mary03-01-2014 Mary03-01-201403-01-2012

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!

Expression

Accepted answers

All comments

rzdodson

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

Solution.yxzp

Grahar

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

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.

Solution_toStartDate.yxmd

rzdodson

@Grahar these are the screenshots you requested.

Formula 2.png

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/

For Grahar.yxmd

flying008

Hi, @Grahar

FYI.

录制_2023_11_20_09_55_35_170.gif

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335