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 derfloh 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
Joined
Apr 25, 2003
Messages
152
Location
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