Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Formula for Choosing Date 2

Status
Not open for further replies.

beadedbytes

Technical User
Apr 25, 2003
152
US
I've been trying to figure out if there's an Excel formula that would accomplish the following:

Code:
ORIG_DT	        DATE_1	        DATE_2	        DATE_3	        DATE_4	        RESULT
11/17/2011	4/13/2010	7/13/2010	10/21/2010	12/27/2011	12/27/2011
5/29/2013	7/3/2013	8/10/2013	9/16/2013	11/29/2013	7/3/2013
8/16/2012	12/12/2009		        1/16/2013	7/11/2013	1/16/2013
9/18/2013	7/13/2011	10/12/2013	11/5/2013	12/6/2013	10/12/2013
5/16/2012	7/14/2011		        6/15/2012	8/11/2013	6/15/2012

For every row, find the 1st date in the DATE_1 through DATE_4 range that falls *after* the ORIG-DT.
Return that date in the RESULT field.

NOTE: Blank cells should be 'ignored' in the analysis.

Thanks in advance for feedback!

 

My grandparents on my mother's side were from a town north of Budapest, Hungary circa 1900.

Skip,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
A beautiful city, Budapest.
I was there in 2000 for a week.

My respects,
Vilhelm-Ion Praisach
Resita, Romania
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top